Quote:
Yesterday at 04:39 PM Bitsys said this in Post #1290
slashboy, What are the values of all the IDs from the items_cats table? Also, do you have any presonal itemshops?
I have been able to reproduce the error artificially, so I think I know how to fix it after the error occurs. However, I still have not located the bug that causes the error.
|
mysql> show columns from items_cats;
+----------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | | PRI | NULL | auto_increment |
| name | char(50) | | | | |
| description | char(250) | | | 0 | |
| catorder | int(2) | | | 0 | |
| type | tinyint(4) | | | 0 | |
| ownerid | int(11) | | | 0 | |
| sold | int(11) | | | 0 | |
| profit | int(11) | | | 0 | |
| battletype | int(10) | | | 0 | |
| itemonofforder | int(3) | | | 0 | |
+----------------+------------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)
yes i have a few personal item shops.... i think thats the problem, coz after i removed the personal itemshops.. everything seems fine..