Profile Page SQL Er...
 
Notifications
Clear all

Profile Page SQL Error

3 Posts
2 Users
0 Reactions
1,501 Views
(@gokugirl)
Posts: 60
Trusted Member
Topic starter
 

http://www.gokugirl.com/test2/

There are only two accounts: my admin one and a test account. When I click on the link to my profile page I get this error:

Warning: mysql_query(): Unable to save result set in /.../.../.../test2/includes/dbfunctions.php on line 18
A fatal MySQL error was encountered.
Query: SELECT * FROM test2fanfiction_authorinfo WHERE uid = '1'
Error: (1030) Got error 127 from table handler

The test account works fine. This archive was one that didn't upgrade to 3.1 like it should have so I had go through update.php line by line to upgrade it to 3.2 (this topic here).


- My eFiction Skins: http://www.gokugirl.com/efiction.php
- The Otaku Institute: http://oi.gokugirl.com
- The OI Same-Sex Archive: http://oisa.gokugirl.com
- The Dragon Ball Fanfiction Library: http://dbfl.gokugirl.com

 
Posted : 13/04/2007 9:40 pm
(@tammy)
Posts: 2577
Member Moderator
 

Seems to be an issue with your database.  Why don't you try going into phpMyAdmin and repairing and optimizing the tables.


 
Posted : 15/04/2007 10:39 am
(@gokugirl)
Posts: 60
Trusted Member
Topic starter
 

That fixed my problem. Thank you.


- My eFiction Skins: http://www.gokugirl.com/efiction.php
- The Otaku Institute: http://oi.gokugirl.com
- The OI Same-Sex Archive: http://oisa.gokugirl.com
- The Dragon Ball Fanfiction Library: http://dbfl.gokugirl.com

 
Posted : 18/04/2007 12:28 am
Share: