Web Wiz Support and Community Forums : mysql new post error ..help please https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 07:30:37 +0000 Wed, 02 Aug 2006 16:06:39 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20877 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[mysql new post error ..help please : yes borg ..that was problem ...i...]]> https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111967.html#111967 Author: get_up
Subject: 20877
Posted: 02 August 2006 at 4:06pm

yes borg ..that was problem ...i installed my earlier backup access and everything is ok...]]> Wed, 02 Aug 2006 16:06:39 +0000 https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111967.html#111967 <![CDATA[mysql new post error ..help please : It looks like your Access database...]]> https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111939.html#111939 Author: WebWiz-Bruce
Subject: 20877
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.
]]> Wed, 02 Aug 2006 09:17:28 +0000 https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111939.html#111939 <![CDATA[mysql new post error ..help please : This time i proove it on access...]]> https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111908.html#111908 Author: get_up
Subject: 20877
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 :(
]]> Tue, 01 Aug 2006 21:00:44 +0000 https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111908.html#111908 <![CDATA[mysql new post error ..help please : I&#039;ve never used phpmyadmin...]]> https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111902.html#111902 Author: WebWiz-Bruce
Subject: 20877
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.
]]> Tue, 01 Aug 2006 18:03:40 +0000 https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111902.html#111902 <![CDATA[mysql new post error ..help please : i have phpmyadmin panel for mysql...]]> https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111901.html#111901 Author: get_up
Subject: 20877
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]]> Tue, 01 Aug 2006 17:43:17 +0000 https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111901.html#111901 <![CDATA[mysql new post error ..help please : It looks like there is an issue...]]> https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111898.html#111898 Author: WebWiz-Bruce
Subject: 20877
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.]]> Tue, 01 Aug 2006 17:19:57 +0000 https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111898.html#111898 <![CDATA[mysql new post error ..help please : i pass on mysql server ..everything...]]> https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111890.html#111890 Author: get_up
Subject: 20877
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


]]> Tue, 01 Aug 2006 15:39:06 +0000 https://forums.webwiz.net/mysql-new-post-error-help-please_topic20877_post111890.html#111890