Saving modules cause SQL errors
- Status
- Closed
- Subject
- Saving modules cause SQL errors
- Version
- 7.x
- Category
- Error
- Feature
- Modules
- Submitted by
- mheller
- Lastmod by
- mheller
- Rating
- Description
Edit and save a module.
System error.The following error message was returned:
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 'UPDATE `tiki_modules` SET `ord`=2, `position`='l' WHERE `moduleId`=16;UPDATE `ti' at line 1
The query was:UPDATE `tiki_modules` SET `ord`=?, `position`=? WHERE `moduleId`=?;UPDATE `tiki_modules` SET `ord`=?, `position`=? WHERE `moduleId`=?;UPDATE `tiki_modules` SET `ord`=?, `position`=? WHERE `moduleId`=?;UPDATE `tiki_modules` SET `ord`=?, `position`=? WHERE `moduleId`=?;UPDATE `tiki_modules` SET `ord`=?, `position`=? WHERE `moduleId`=?;UPDATE `tiki_modules` SET `ord`=?, `position`=? WHERE `moduleId`=?;UPDATE `tiki_modules` SET `ord`=?, `position`=? WHERE `moduleId`=?;UPDATE `tiki_modules` SET `ord`=?, `position`=? WHERE `moduleId`=?;UPDATE `tiki_modules` SET `ord`=?, `position`=? WHERE `moduleId`=?;UPDATE `tiki_modules` SET `ord`=?, `position`=? WHERE `moduleId`=?;UPDATE `tiki_modules` SET `ord`=?, `position`=? WHERE `moduleId`=?;UPDATE `tiki_modules` SET `ord`=?, `position`=? WHERE `moduleId`=?;
Values:4
t
28
2
l
16
3
l
20
4
l
2
1
r
21
2
r
22
3
r
9
4
r
10
5
r
5
6
r
8
1
b
29
2
b
30
The built query was likely:UPDATE `tiki_modules` SET `ord`='4', `position`='t' WHERE `moduleId`='28';UPDATE `tiki_modules` SET `ord`='2', `position`='l' WHERE `moduleId`='16';UPDATE `tiki_modules` SET `ord`='3', `position`='l' WHERE `moduleId`='20';UPDATE `tiki_modules` SET `ord`='4', `position`='l' WHERE `moduleId`='2';UPDATE `tiki_modules` SET `ord`='1', `position`='r' WHERE `moduleId`='21';UPDATE `tiki_modules` SET `ord`='2', `position`='r' WHERE `moduleId`='22';UPDATE `tiki_modules` SET `ord`='3', `position`='r' WHERE `moduleId`='9';UPDATE `tiki_modules` SET `ord`='4', `position`='r' WHERE `moduleId`='10';UPDATE `tiki_modules` SET `ord`='5', `position`='r' WHERE `moduleId`='5';UPDATE `tiki_modules` SET `ord`='6', `position`='r' WHERE `moduleId`='8';UPDATE `tiki_modules` SET `ord`='1', `position`='b' WHERE `moduleId`='29';UPDATE `tiki_modules` SET `ord`='2', `position`='b' WHERE `moduleId`='30';
Things to check:Is your database up and running?
Is your database corrupt? Please see how to repair your database
Are your database credentials accurate? (username, database name, etc in db/local.php)
Did you complete the Tiki Installer?
Please see the documentation for more information.- Importance
- 7
- Priority
- 35
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 3779
- Created
- Tuesday 01 February, 2011 17:51:30 UTC
by mheller - LastModif
- Wednesday 20 April, 2011 15:35:48 UTC