Register | Login | |||||
Main
| Memberlist
| Active users
| ACS
| Commons
| Calendar
| Online users Ranks | FAQ | Color Chart | Photo album | IRC Chat |
| |
0 user currently in Acmlmboard support?. |
Acmlm's Board - I2 Archive - Acmlmboard support? - Help | | | |
Add to favorites | "RSS" Feed | Next newer thread | Next older thread |
User | Post | ||
Ringodoggie Snifit Level: 27 Posts: 243/281 EXP: 114340 For next: 1819 Since: 03-23-04 From: London, Ontario, Canada Since last post: 27 days Last activity: 5 hours |
| ||
I tried inserting acmlm_db.sql (which came with acmlmboard 1.a3) using phpmyadmin and I get this problem: Error SQL-query: CREATE TABLE `actionlog` ( `id` mediumint( 9 ) NOT NULL AUTO_INCREMENT , `atime` varchar( 15 ) NOT NULL default '', `adesc` mediumtext NOT NULL , `aip` text NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 MySQL said: Documentation #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 'DEFAULT CHARSET=latin1' at line 7 |
|||
ExKay Somebody set up us the bomb! Level: 50 Posts: 826/1114 EXP: 908268 For next: 39049 Since: 03-15-04 From: Hannover, Germany Since last post: 14 hours Last activity: 1 hour |
| ||
Try this: CREATE TABLE `actionlog` ( `id` mediumint(9) NOT NULL auto_increment, `atime` varchar(15) NOT NULL default '', `adesc` mediumtext NOT NULL, `aip` text NOT NULL , PRIMARY KEY (`id`) ) TYPE=MyISAM PACK_KEYS=0 (edited by Ice Man on 07-21-05 05:57 AM) |
|||
TheGreatWhiteDope Koopa Banned Level: 16 Posts: 39/108 EXP: 19462 For next: 794 Since: 01-05-05 Since last post: 8 days Last activity: 4 days |
| ||
When I set up 1.A3, I had to get rid of ever "DEFAULT CHARSET=latin1" for it to work and I just ended up switching back to 1.A2 because 1.A3 is way to glitchy... (edited by TheGreatWhiteDope on 07-22-05 08:58 PM) |
|||
Xeolord - B l u e s - Power Metal > All Level: 81 Posts: 2729/3418 EXP: 4884196 For next: 108653 Since: 03-15-04 From: Yeah Since last post: 15 hours Last activity: 15 hours |
| ||
Originally posted by Ringodoggie I did basically what TheGreatWhiteDope said, instead of inputting that into the SQL, put in: CREATE TABLE `actionlog` ( `id` mediumint( 9 ) NOT NULL AUTO_INCREMENT , `atime` varchar( 15 ) NOT NULL default '', `adesc` mediumtext NOT NULL , `aip` text NOT NULL , PRIMARY KEY ( `id` ) ) That should work. Hopefully it's not a big deal if you leave that other part out. (edited by Xeolord on 07-23-05 07:49 PM) |
Add to favorites | "RSS" Feed | Next newer thread | Next older thread |
Acmlm's Board - I2 Archive - Acmlmboard support? - Help | | | |