| Author |
 Topic  |
|
|
cdmilton
Starting Member
15 Posts |
 Posted - 31 January 2007 : 16:53:56
|
Snitz Forums 2000 Version 3.4.03
I might be having issues with MySQL 5.0.22. When a new topic is posted there is no topic_id created and it is null in the table. When I try to delete the topic I get an error similar to the following:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-max-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server vers
ion for the right syntax to use near 'AND M.M_STATUS = 1' at line 1
/Forum/pop_delete.asp, line 820
I recently converted from MsSQL and moved to a real web host from a local web server. Everything was fine before the move.
Any ideas?
Chris |
Edited by - cdmilton on 31 January 2007 16:57:15 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
cdmilton
Starting Member
15 Posts |
Posted - 31 January 2007 : 17:06:18
|
quote:
Originally posted by ruirib
The problem results surely from the way you did the conversion. Did you create the tables, using setup.asp, before converting?
I did not. I was getting errors when doing that with the latest version. Should I download and try again? |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 31 January 2007 : 18:04:12
|
Version 3.4.03 rui. 
You moved from MS SQL to MySQL? Why would you do that? Unless your new host didn't support it. |
Support Snitz Forums
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 31 January 2007 : 18:12:18
|
| If you can do it, I would recommend the creation of a new, blank, 3.4.03 database. Then use whatever tool you have (phpMyadmin, for example) to export just the data from your current MySQL DB and import, just the data to the new MySQL DB. Then change your config.asp to use the new, properly created, MySQL DB. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
cdmilton
Starting Member
15 Posts |
Posted - 31 January 2007 : 18:16:44
|
quote:
Originally posted by Davio
Version 3.4.03 rui.
You moved from MS SQL to MySQL? Why would you do that? Unless your new host didn't support it.
The new host didn't support MS Sql in the package I picked. |
|
|
| |
Topic |
|
Topic Locked
