Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Back-office allows longer description than accepted at database level #451

Open
sentry-io bot opened this issue Sep 14, 2021 · 1 comment
Open

Back-office allows longer description than accepted at database level #451

sentry-io bot opened this issue Sep 14, 2021 · 1 comment
Labels

Comments

@sentry-io
Copy link

sentry-io bot commented Sep 14, 2021

Sentry Issue: BACKEND-G1

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1
  File "/public/index.php", line 28
    $response = $kernel->handle($request);
...
(12 additional frame(s) were not displayed)

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1
  File "/public/index.php", line 28
    $response = $kernel->handle($request);
...
(12 additional frame(s) were not displayed)

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO matching_context (exampleUrl, urlRegex, excludeUrlRegex, description, querySelector, xpath, notice_id) VALUES (?, ?, ?, ?, ?, ?, ?)' with params ["https:\/\/www.amazon.fr\/Infantino-980-004915-00-projector-musical-mobile\/dp\/B00VAKUKC2\/ref=sr_1_7?__mk_fr_FR=%C3%85M%C3%85%C5%BD%C3%95%C3%91&dchild=1&keywords=mobile+musical+b%C3%A9b%C3%A9&qid=1630306060&sr=8-7", ".*(\/dp)", null, "\/\/span[@id='productTitle']\/text()[contains(translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXYZ\u00c0\u00c2\u00c4\u00c7\u00c9\u00c8\u00ca\u00cb\u00ce\u00cf\u00d9\u00db\u00dc' , 'abcdefghijklmnopqrstuvwxyz\u00e0\u00e2\u00e4\u00e7\u00e9\u00e8\u00ea\u00eb\u00ee\u00ef\u00f9\u00fb\u00fc'), 'musical') and contains(translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXYZ\u00c0\u00c2\u00c4\u00c7\u00c9\u00c8\u00ca\u00cb\u00ce\u00cf\u00d9\u00db\u00dc' , 'abcdefghijklmnopqrstuvwxyz\u00e0\u00e2\u00e4\u00e7\u00e9\u00e8\u00ea\u00eb\u00ee\u00ef\u00f9\u00fb\u00fc'), 'mobile'] or \/\/span[@id='productTitle']\/text()[contains(translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXYZ\u00c0\u00c2\u00c4\u00c7\u00c9\u00c8\u00ca\u00cb\u00ce\u00cf\u00d9\u00db\u00dc' , 'abcdefghijklmnopqrstuvwxyz\u00e0\u00e2\u00e4\u00e7\u00e9\u00e8\u00ea\u00eb\u00ee\u00ef\u00f9\u00fb\u00fc'), 'musical') and contains(translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXYZ\u00c0\u00c2\u00c4\u00c7\u00c9\u00c8\u00ca\u00cb\u00ce\u00cf\u00d9\u00db\u00dc' , 'abcdefghijklmnopqrstuvwxyz\u00e0\u00e2\u00e4\u00e7\u00e9\u00e8\u00ea\u00eb\u00ee\u00ef\u00f9\u00fb\u00fc'), 'doudou'] or \/\/span[@id='productTitle']\/text()[contains(translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXYZ\u00c0\u00c2\u00c4\u00c7\u00c9\u00c8\u00ca\u00cb\u00ce\u00cf\u00d9\u00db\u00dc' , 'abcdefghijklmnopqrstuvwxyz\u00e0\u00e2\u00e4\u00e7\u00e9\u00e8\u00ea\u00eb\u00ee\u00ef\u00f9\u00fb\u00fc'), 'musical') and contains(translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXYZ\u00c0\u00c2\u00c4\u00c7\u00c9\u00c8\u00ca\u00cb\u00ce\u00cf\u00d9\u00db\u00dc' , 'abcdefghijklmnopqrstuvwxyz\u00e0\u00e2\u00e4\u00e7\u00e9\u00e8\u00ea\u00eb\u00ee\u00ef\u00f9\u00fb\u00fc'), 'peluche']", null, null, 2232]:

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1
  File "/public/index.php", line 28
    $response = $kernel->handle($request);
...
(14 additional frame(s) were not displayed)
@MaartenLMEM
Copy link
Contributor

Pas d'urgence. Peu probable que ça se reproduise
Mais enquiquinant car le contributeur ne sait jamais pourquoi il a eu erreur 500. Et souvent quand on a erreur 500 on perd tout notre contenu.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant