Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 MySQL returns the following error when attempting

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
mkervin Posted - 01 April 2011 : 13:20:52
to delete a post.

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 5.1 Driver][mysqld-5.5.10]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 'AND M.M_STATUS = 1' at line 1

I also get a message that there is an error in line 836 in pop_delete.asp

set rsCheck = my_Conn.Execute (strSql)

=================================================================
This database is a converted Access db and I am testing it now on our local machine.

Another problem I discovered is when I add a new topic it doesn't open the topic it opens another one with my login name on it and if I attempt to click on the topic it throws me to the main default.asp page. Any ideas?

I won't bring this live until it works correctly. Right now this board is still running on an Access DB platform without errors.
5   L A T E S T    R E P L I E S    (Newest First)
mkervin Posted - 02 April 2011 : 01:34:48
OK I copied everything over to MySQL and I then did my mods so it added the proper fields too. I can browse my formum but I can't log in. When I type my user name and password it tells me I am logged in but I am not. It doesn't say my name under the log in and I can't edit a post. etc. What table would be causing this so I can check the values to see why I am not able to log in as a member or the administrator.
mkervin Posted - 01 April 2011 : 18:18:44
I will give it a try right now. Thanks!

OK HeidiSQL won't allow me to import the data and MS Access will not export just the data for me. Do you have any suggestions on which app will allow me to export the data from the Access tables into the tables in MySQL?
HuwR Posted - 01 April 2011 : 15:55:14
they may have got mangled in the export, the best solution is to use the setup.asp page of the forum to create the tables for you, then export just the data from access to mysql
mkervin Posted - 01 April 2011 : 15:36:47
No HuwR this was originally an Access database that I converted to MySQL via an export from MS Access using the OBDC data source. Originally, the forum was created using your setup page, I did not create or alter any fields other than the ones which Snitz created, and way back when it was created as an Access database forum.

Where do I find what fields need to be converted to a different data type in MySQL after the import? I really can use some help.

I love using Snitz on our site and would like to get this all figured out and running on MySQL.
HuwR Posted - 01 April 2011 : 14:50:55
sounds like maybe some of the columns are not the correct type, did you use the forum to create the mysql database?

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000 Version 3.4.07