Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - mysql new post error ..help please
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

mysql new post error ..help please
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
get_up View Drop Down
Groupie
Groupie
Avatar

Joined: 07 April 2006
Status: Offline
Points: 40 		Post Options Post Options   Thanks (0) Thanks(0)   Quote get_up Quote  Post ReplyReply Direct Link To This Post Topic: mysql new post error ..help please
    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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
get_up View Drop Down
Groupie
Groupie
Avatar

Joined: 07 April 2006
Status: Offline
Points: 40 		Post Options Post Options   Thanks (0) Thanks(0)   Quote get_up Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
get_up View Drop Down
Groupie
Groupie
Avatar

Joined: 07 April 2006
Status: Offline
Points: 40 		Post Options Post Options   Thanks (0) Thanks(0)   Quote get_up Quote  Post ReplyReply Direct Link To This Post 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 :(
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
get_up View Drop Down
Groupie
Groupie
Avatar

Joined: 07 April 2006
Status: Offline
Points: 40 		Post Options Post Options   Thanks (0) Thanks(0)   Quote get_up Quote  Post ReplyReply Direct Link To This Post Posted: 02 August 2006 at 4:06pm
yes borg ..that was problem ...i installed my earlier backup access and everything is ok...
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.