had to do it as a link as cannot attach txt files :-( Sorry to post here as well but I am absolutely desparate!
To recap all of problem.....
New client began to add categories. Added one then did the same procedure to add another. Ended up with a category (together with all sub-cats) that I had put in disappearing. I regenerated and it threw a wobbly! Now user-end of site is down. I can get into admin but it won't let me look at categories.
Looking at database it has done some weird things but I don't know how to recify it. There is a section that simply repeats the titles of the cats client submitted: , Aromatics for animals, T Shirts, and then repeats , 13, 2
Since you didn't use full inserts, I have no idea what fields those are in the database. You need to check the 'full inserts' box when making an export of a database so that it lists the field names.
If there are no tables that are listed as needing a repair and removing the junk content by hand doesn't do anything, the only thing I could suggest is stepping through prestart.php line by line to see where it dies. It appears to be just after
$highestcatindex = $db->rowitem($db->select('id', 'categoriestable', 'validated=1 AND hide=0 AND isalbum=0', 'ORDER BY id DESC', 'LIMIT 0,1'));
which suggests that the categories database table is dead in some sort of way that causes mysql and php to choke and die without returning an error message.
Paul wrote: You need to check the 'full inserts' box when making an export of a database so that it lists the field names.[/code]
Thank you, I didn't know that.
[quote=Paul] stepping through prestart.php line by line to see where it dies. It appears to be just after [code]$highestcatindex = $db->rowitem($db->select('id', 'categoriestable', 'validated=1 AND hide=0 AND isalbum=0', 'ORDER BY id DESC', 'LIMIT 0,1'));
which suggests that the categories database table is dead in some sort of way that causes mysql and php to choke and die without returning an error message.
So does that mean that I've lost everything and have to make a new database? Or is there anyway I can recover it? I previously tried running repair database but it did nothing and is not reporting any errors.
Comments on Problem with Cats - HELP!
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Paul, further to my contact to you concerning this problem, herewith copy of database.
http://www.barkery.co.uk/new/data.txt
had to do it as a link as cannot attach txt files :-( Sorry to post here as well but I am absolutely desparate!
To recap all of problem.....
New client began to add categories. Added one then did the same procedure to add another. Ended up with a category (together with all sub-cats) that I had put in disappearing. I regenerated and it threw a wobbly! Now user-end of site is down. I can get into admin but it won't let me look at categories.
Looking at database it has done some weird things but I don't know how to recify it. There is a section that simply repeats the titles of the cats client submitted: , Aromatics for animals, T Shirts, and then repeats , 13, 2
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Since you didn't use full inserts, I have no idea what fields those are in the database. You need to check the 'full inserts' box when making an export of a database so that it lists the field names.
If there are no tables that are listed as needing a repair and removing the junk content by hand doesn't do anything, the only thing I could suggest is stepping through prestart.php line by line to see where it dies. It appears to be just after
which suggests that the categories database table is dead in some sort of way that causes mysql and php to choke and die without returning an error message.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
You need to check the 'full inserts' box when making an export of a database so that it lists the field names.[/code]
Thank you, I didn't know that.
[quote=Paul] stepping through prestart.php line by line to see where it dies. It appears to be just after
[code]$highestcatindex = $db->rowitem($db->select('id', 'categoriestable', 'validated=1 AND hide=0 AND isalbum=0', 'ORDER BY id DESC', 'LIMIT 0,1'));
which suggests that the categories database table is dead in some sort of way that causes mysql and php to choke and die without returning an error message.
So does that mean that I've lost everything and have to make a new database? Or is there anyway I can recover it? I previously tried running repair database but it did nothing and is not reporting any errors.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Got it working!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! PHEW!
What I did was to export the database, managed to find what client had put in and delete it.
I made a new database, uploaded new wsnlinks, imported amended data.