Web Wiz Forums - mysql new post error ..help please

Print Page | Close Window

mysql new post error ..help please

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=20877
Printed Date: 09 April 2026 at 7:28am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: mysql new post error ..help please

Posted By: get_up
Subject: mysql new post error ..help please
Date Posted: 01 August 2006 at 3:39pm

i pass on mysql server ..everything is ok but i cant send post to topics ..error seems like this::

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_topic_data
File Name:- new_post.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
Duplicate entry '0' for key 1

Replies:

Posted By: WebWiz-Bruce
Date Posted: 01 August 2006 at 5:19pm

It looks like there is an issue with your mySQL database and the auto_increment is not working for the ID fields in some of your database tables.

If it is a clean database, try deleting it and starting again.

If you can not do this check that the primary key (usually the first column in each table with _ID at the end) is set to auto_increment so that the database generates a new ID number for each record.

-------------
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: get_up
Date Posted: 01 August 2006 at 5:43pm

i have phpmyadmin panel for mysql .. where can i change those things here ... i think that if i wont choose this problem tonight ill turn back to my access even that its 30 mb... mysql is very complicated

Posted By: WebWiz-Bruce
Date Posted: 01 August 2006 at 6:03pm

I've never used phpmyadmin so I can't help you there.

But I would imagine that you should be able to modify the tables with it.

However, it sounds like when you converted from Access to mySQL that the tool you used didn't carry across the default values. You may need to do the conversion again but this time make sure that the default values are also carried across.

-------------
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: get_up
Date Posted: 01 August 2006 at 9:00pm

This time i proove it on access and when i try to log on :

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

Support Error Code:- err_Access_loginUser()_update_USR_Code
File Name:- functions_login.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
Query-based update failed because the row to update could not be found.
...

guys i dont know what happens but im going to be crazy tonight :(

Posted By: WebWiz-Bruce
Date Posted: 02 August 2006 at 9:17am

It looks like your Access database is corrupted, which is very common with Access as it is a naff database system.

You need to download the Access database, open in MS Access, and then select, 'compact and repair database' from the tools menu.

-------------
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: get_up
Date Posted: 02 August 2006 at 4:06pm

yes borg ..that was problem ...i installed my earlier backup access and everything is ok...