Quote:
Originally Posted by calvinnguyen
I saw the line below at config.php
$tableprefix = ' ';
Do I add this line in like as below: BUT WHEN I RUN IT STILL GIVE ME ERROR. I am really don't know how to run sql
Error
SQL-query :
$tableprefix = ' '
MySQL said:
#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 '$tableprefix = ' '' at line 3
ALTER TABLE `forum` ADD `showthanks` INT(1) DEFAULT '0' NOT NULL;
ALTER TABLE `forum` ADD `showthanks_date` INT(1) DEFAULT '0' NOT NULL;
$tableprefix = '';
CREATE TABLE `thanks` (
`id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`userid` INT(10) NOT NULL,
`username` VARCHAR(50) NOT NULL,
`date` INT(10) NOT NULL,
`threadid` INT(10) NOT NULL
);
|
Anyone can help me with this problem above. Many thanks