Loading...
 
Skip to main content

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
(0)
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+
Demonstrate Bug (older Tiki versions)
Ticket ID
3779
Created
Tuesday 01 February, 2011 17:51:30 UTC
by mheller
LastModif
Wednesday 20 April, 2011 15:35:48 UTC


Show PHP error messages