Web Wiz Forums - mysql server problems after Access conver

Print Page | Close Window

mysql server problems after Access conver

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20982
Printed Date: 09 April 2026 at 8:26am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: mysql server problems after Access conver

Posted By: semih1
Subject: mysql server problems after Access conver
Date Posted: 10 August 2006 at 6:46pm

i convert my access db to mysql. the data have no problem.

when i try to post new message or open a new topic or while editing the profiles i see this error:

for example while editing the member profiles:

Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_mySQL_update_USR
File Name:- register.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Invalid string or buffer length

-----------------

all errors detalis are:
Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Invalid string or buffer length

what can i do ? have you got an opinion?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 11 August 2006 at 9:34am

Try changing line 709 of the file register.asp to:-

strSQL = "SELECT " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.Group_ID, " & strDbTable & "Author.Username, " & strDbTable & "Author.Real_name, " & strDbTable & "Author.User_code, " & strDbTable & "Author.Password, " & strDbTable & "Author.Salt, " & strDbTable & "Author.Author_email, " & strDbTable & "Author.Homepage, " & strDbTable & "Author.Location, " & strDbTable & "Author.MSN, " & strDbTable & "Author.Yahoo, " & strDbTable & "Author.ICQ, " & strDbTable & "Author.AIM, " & strDbTable & "Author.Occupation, " & strDbTable & "Author.Interests, " & strDbTable & "Author.DOB, " & strDbTable & "Author.Signature, " & strDbTable & "Author.No_of_posts, " & strDbTable & "Author.No_of_PM, " & strDbTable & "Author.Join_date, " & strDbTable & "Author.Avatar, " & strDbTable & "Author.Avatar_title, " & strDbTable & "Author.Last_visit, " & strDbTable & "Author.Time_offset, " & strDbTable & "Author.Time_offset_hours, " & strDbTable & "Author.Date_format, " & strDbTable & "Author.Show_email, " & strDbTable & "Author.Attach_signature, " & strDbTable & "Author.Active, " & strDbTable & "Author.Rich_editor, " & strDbTable & "Author.Reply_notify, " & strDbTable & "Author.PM_notify, " & strDbTable & "Author.Skype, " & strDbTable & "Author.Login_attempt, " & strDbTable & "Author.Banned, " & strDbTable & "Author.Info " &_

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: semih1
Date Posted: 11 August 2006 at 1:38pm

i have changed but now i'm taking this error for register.asp:

Microsoft VBScript runtime error '800a000d'

Type mismatch: '[string: "SELECT tblAuthor.Aut"]'

/forumy/register.asp, line 709

Posted By: WebWiz-Bruce
Date Posted: 11 August 2006 at 4:50pm

It looks like you may not have copied the line correctly.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: semih1
Date Posted: 11 August 2006 at 5:55pm

i have changed the codes correctly.

But i have taken the same error:

Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_mySQL_update_USR
File Name:- register.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Invalid string or buffer length

------------
another page :

for trying to open a new topic

Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_mySQL_save_new_post_data
File Name:- new_post.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Invalid string or buffer length

-----------

i can write database using the admin menu, for example i can change the categories name's etc.

Posted By: WebWiz-Bruce
Date Posted: 11 August 2006 at 6:28pm

I have done a search on this on the mySQL site and it seems it is a bug in some versions of mySQL and myODBC.

If you have access to the server try updating the myODBC driver, if you still have the same issue, then try upgrading the version of mySQL you have.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting