Cool. Cheers.
You're a PunBB God in my book!
2 2006-09-18 09:53
Re: Database Changeover probs (9 replies, posted in PunBB 1.2 troubleshooting)
Hi,
Exporting to Mysql 4.0 doesn't allow for auto-increment.
(#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 AUTO_INCREMENT=1' at line 9)
Which table do I need to set up auto incerement on (using the code you gave). Is it just the 'id' of each table or do I need to do every variable in every table?
Thanks
3 2006-09-14 08:13
Re: Database Changeover probs (9 replies, posted in PunBB 1.2 troubleshooting)
what do I need to do to make sure auto_incremenet works? Like I say I know nothing and just exported then imported hoping it would work!?
xconspirisist, thanks for the offer. What PM system do you use?
Thanks
At
4 2006-09-13 10:19
Re: Database Changeover probs (9 replies, posted in PunBB 1.2 troubleshooting)
Exported out data in sql file using phpadmin, and then imported files using phpadmin.
Its a brand-spanking new database, with only these imported files in.
Not sure what you mean by dropping it and creating it again?
5 2006-09-13 09:09
Topic: Database Changeover probs (9 replies, posted in PunBB 1.2 troubleshooting)
Hi,
Switching database from Mysql 4.1 to 4.0.
Exported as 4.0, then imported files. All loads up ok, but first new topic had a "viewtopic.php?id=0" and therefore obviously cant be viewed, and then any topics created after that are met with "An error was encountered Error: Unable to create topic. "
Do I need to activate the files in the new MySql or change permissions or something?
New to Mysql really so any help gratefully received.