Quote:
Originally Posted by shka
Updated your DB server?
"Rows" is a reserved word in MariaDB since 10.2.4
Edit your forms.php and quote the column names with backticks `
, I found this three times
Line 1976
PHP Code:
(`fid`, `displayorder`, `type`, `question`, `description`, `options`, `compulsory`, `perrow`, `rows`, `cols`, `maxlength`, `ereg`, `custom`, `spacer`, `size`, `guestonly`, `minlength`, `reference`, `hidelabel`, `quiz`)
Line 3305
PHP Code:
(`fid`, `displayorder`, `type`, `question`, `description`, `options`, `compulsory`, `rows`, `cols`, `maxlength`, `size`, `perrow`, `ereg`, `custom`, `guestonly`, `minlength`, `reference`, `hidelabel`)
Line 3555
PHP Code:
(`fid`, `displayorder`, `type`, `question`, `description`, `options`, `compulsory`, `rows`, `cols`, `maxlength`, `size`, `perrow`, `ereg`, `custom`, `guestonly`, `minlength`, `reference`, `hidelabel`)
|
Thanks for the quick reply! I have gone ahead and tried this, and given it another try.
This time the error is as follows:
Code:
Database error in vBulletin 4.2.5:
Invalid SQL:
INSERT INTO formbits
(`fid`, `displayorder`, `type`, `question`, `description`, `options`, `compulsory`, `perrow`, `rows`, `cols`, `maxlength`, `ereg`, `custom`, `spacer`, `size`, `guestonly`, `minlength`, `reference`, `hidelabel`, `quiz`)
VALUES ('1', '10', '13', 'Test Scale', 'Test descr', '', '1', '0', '1', '5', '0', '', '', '', '0', '0', '0', '', '0', '');
MySQL Error : Unknown column 'rows' in 'field list'
Error Number : 1054
|