SQL Error adding blockBrowser Info Environment
An exception occurred while executing 'INSERT INTO btMulServiceListingTwo (bID, title, desc, image, intlink, intlink_text, extlink, extlink_text, align, bgcolor, faicon, icoalign, anim) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["16", "Test", "test<\/p>", "1", "0", "", "", "", "", "", "", "", ""]: SQLSTATE: Syntax error or access violation: 1064 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 'desc, image, intlink, intlink_text, extlink, extlink_text, align, bgcolor, faico' at line 1
Any ideas? Other standard blocks add to the page.
I don't know what happened before. I uninstalled that block (that was giving sql error in original post), deleted it, went back and re-built it and it adds and outputs to the page now.
I do know what happened here. For the "Description" input, you've chosen a variable called "desc". This actually is a SQL statement. There is already a blacklist and that will add a numeric value to your slug (like desc1), to avoid this from happening. The "desc" is not in this blacklist though, so I will be adding this. Same goes for "asc" (so ascending and descending). Meanwhile, do not use these 2 SQL statements as variable name, and you should be good to go!
Makes sense? :)
Great package! Looking forward to working with it. Thanks again for all your efforts.
Hope you will fall in love with Block Designer. I'm 100% certain it will save you loads of valuable time.
Note: Also don't use "interval" as a slug name for a field. I think that was the culprit.