I do not have them programs do you know someone I can pay to fix this? You have been a big help I do need to get this fixed for a customer as soon as I can
Dave
this is the error I get #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 'ALTER TABLE users ADD PRIMARY KEY ( id )
LIMIT 0, 30' at line 1
I downloaded this from the one that works
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(15) NOT NULL default '',
`password` varchar(10) NOT NULL default '',
`join_date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_access` datetime NOT NULL...
on the create table it is built into an install on the program and failed to create 2 tables when I loaded what i did was copy from the other database that loaded properly and works ironicly the second one still will not work properly
Dave
Hi I loaded a program and use the data base on MySQL 4.0.22-standard the program runs fine. I loaded the same program on MySQL - 4.1.13-log and have issues the problem that I see is on the user tables on MySQL 4.0.22-standard PRIMARY PRIMARY 2 id
id UNIQUE 2 id
id_2 INDEX None id...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.