Jump to content

Search the Community

Showing results for tags 'sql error'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Welcome to ProcessWire
    • News & Announcements
    • Showcase
    • Wishlist & Roadmap
  • Community Support
    • Getting Started
    • Tutorials
    • FAQs
    • General Support
    • API & Templates
    • Modules/Plugins
    • Themes and Profiles
    • Multi-Language Support
    • Security
    • Jobs
  • Off Topic
    • Pub
    • Dev Talk

Product Groups

  • Form Builder
  • ProFields
  • ProCache
  • ProMailer
  • Login Register Pro
  • ProDrafts
  • ListerPro
  • ProDevTools
  • Likes
  • Custom Development


There are no results to display.

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start





Website URL







Found 2 results

  1. 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 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
  2. 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
  • Create New...