XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Strange Table Check error:My SQL
Register
1
DobePhat
Strange Table Check error:My SQL

  • 2004/8/22 2:54

  • DobePhat

  • Friend of XOOPS

  • Posts: 656

  • Since: 2003/4/15


Don't know if anyone can help with this.
Apparently we may have had a dropped table from MYsql, DB?

Now we are getting a warning when running table check.
"Warning:row autoincrement found set to 0"

Have no idea what that means...or if its even important...never encountered it before. Was just doing a routine table check.

Any suggestions, as usual, greatly appreciated.
2
Dave_L
Re: Strange Table Check error:My SQL

  • 2004/8/22 3:55

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


That could interfere with proper insertion of rows into that table.

Have you tried repairing the table?

If that doesn't help, you can set the auto-increment value for a table with a query like the following:

ALTER TABLE xoops_avatars AUTO_INCREMENT=31

Also, phpMyAdmin has this function built into its GUI.

If you drop a table and then recreate it, though, I would think that the auto-increment value would get set automatically.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

419 user(s) are online (121 user(s) are browsing Support Forums)

Members: 0

Guests: 419

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Aug 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits