Search the Community
Showing results for tags 'sql error'.
Found 2 results
Hi, hopefully you can give me some advice on debugging an error with a ProcessWire 2.5 site using ShoppingCart module (and Version Control module): When guest users try to add a specific product to the shopping cart, a "500 Internal Server Error" page is thrown and the following error is logged in assets/logs/errors.txt: 2015-05-25 18:28:06 guest http://127.0.0.1/pw/product-12 Error: Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '01, session_id = 'd41a2726a1f1d8205f45ce240da65af10517c74f' ON DUPLICATE KEY UPD' at line 1 (in /var/www/pw/wire/core/Database.php line 114) Since only a part of the SQL error is shown, I have difficulties to find out what's wrong here. The error does only occur with two products (a hundred others are fine) and only with guest users. If I add these products as a logged in admin, everything works great. The database tables do not include a session ID d41a2726a1f1d8205f45ce240da65af10517c74f. How do I get a more specific error message from ProcessWire? Thanks Sarah
Hello clever peeps, Anyone seen this/knows where to start trying to solve it? Page: http://mysite.com/?/ User: guest Error: Exception: SQLSTATE[HY000]: General error: 1116 Too many tables; MySQL can only use 61 tables in a join (in /home/mysite/public_html/wire/core/DatabaseQuery.php line 91) PW config.php has my email address so I am emailed errors and I just received this by email. the site appears fine that URL does not throw a 404 whereas something like http://mysite.com/testfora404etc will, as it should, throw a good 404 Any pointers most appreciated, cheers, -Alan ProcessWire v:2.5.3 + Form Builder v:0.2.2