before the include of the inc stats php file /home/*username*/public_html/ppc/splittester-pilot/template2.php after the include of the inc stats php file
echo 'before the include of the inc stats php file  ';
include_once(ROTATOR_DIR."/slimstat/inc.stats.php");
echo ' after the include of the inc stats php file';
[B]Error[/B]
[B]SQL query:[/B]
CREATE TABLE `ad_clicks` ( `id` int( 20 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) NOT NULL ,
`from` varchar( 255 ) NOT NULL ,
`unit` varchar( 20 ) NOT NULL ,
`browser` varchar( 255 ) NOT NULL ,
`adunitsize` varchar( 100 ) NOT NULL ,
`template` varchar( 255 ) NOT NULL ,
`adtype` varchar( 255 ) NOT NULL ,
`time` timestamp NOT NULL default CURRENT_TIMESTAMP ,
PRIMARY KEY ( `id` ) ,
KEY `from` ( `from` )
) ENGINE = MYISAM AUTO_INCREMENT =4DEFAULT CHARSET = latin1 AUTO_INCREMENT =4;
[B]MySQL said: [/B][URL="http://dev.mysql.com/doc/refman/4.1/en/error-returns.html"][IMG]https://mysqladmin2.secureserver.net/80/themes/original/img/b_help.png[/IMG][/URL]
#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 'CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `from` (`fr
Lerch, I'm getting this message when loading the SQL from the rotator/config.php file:
Lerch, I'm getting this message when loading the SQL from the rotator/config.php file:
Any thoughts?Code:[B]Error[/B] [B]SQL query:[/B] CREATE TABLE `ad_clicks` ( `id` int( 20 ) NOT NULL AUTO_INCREMENT , `title` varchar( 255 ) NOT NULL , `from` varchar( 255 ) NOT NULL , `unit` varchar( 20 ) NOT NULL , `browser` varchar( 255 ) NOT NULL , `adunitsize` varchar( 100 ) NOT NULL , `template` varchar( 255 ) NOT NULL , `adtype` varchar( 255 ) NOT NULL , `time` timestamp NOT NULL default CURRENT_TIMESTAMP , PRIMARY KEY ( `id` ) , KEY `from` ( `from` ) ) ENGINE = MYISAM AUTO_INCREMENT =4DEFAULT CHARSET = latin1 AUTO_INCREMENT =4; [B]MySQL said: [/B][URL="http://dev.mysql.com/doc/refman/4.1/en/error-returns.html"][IMG]https://mysqladmin2.secureserver.net/80/themes/original/img/b_help.png[/IMG][/URL] #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 'CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `from` (`fr
Thanks!
~Mike~
Maybe the single quotes are messing you up. instead, try to use double quotes to surround the entire command.
mysql_query("CREATE TABLE ad_clicks(id INT(20) NOT NULL, title VARCHAR(255) NOT NULL, ETC ETC ETC)")
Plus, the line breaks could be messing up the script. put everything on one line(if it already isn't on one line). also, what is the engine for? doesn't mysql do this automatically?
Its because "CURRENT_TIMESTAMP" doesn't work for versions before 4.0. Everything you said is WRONG.