WampServer

Hi,

I hope someone can help me with this problem. Until now I have had no problems backing up my tables in my offline TNG database, but suddenly I got this error message:


( ! ) Warning: mysql_query() [function.mysql-query]: Unable to save result set in C:\wamp\www\Genealogi\admin_backup.php on line 36
Call Stack
# Time Memory Function Location
1 0.0033 771656 {main}( ) ..\admin_backup.php:0
2 0.0586 1765176 backup( ) ..\admin_backup.php:144
3 0.0618 1766544 mysql_query ( ) ..\admin_backup.php:36
Cannot execute query: SELECT * FROM tng_families LIMIT 0, 10000

I hadn't noticed, but the line for the families table in TNG Admin says 0 kb. But in my PHPAdmin it says 446 kb.

The error appears, both when I try to back up all tables at one time (because the families table is included) or just the families table alone. But I have no problem taking backup of all the other tables at the same time, just as long as I leave the families table unchecked. And I don't have any problem backing up one table at a time, except for the families table.

Wampserver 2.2
PHP version 5.3.8
MySql version 5.5.16

Windows 8, 64 bit

Does anyone have an idea, what the problem might be?

Kind regards
Vanda

First off can you try repairing the table, just in case that is the problem.


left click wampmanager -> MySQL -> MySQL console

enter the password for 'root' or just hit enter is you have not added a password to the root account.
> use YourDatabase Name;
> repair table tng_families;


You could also use phpMyAdmin if you prefer.

I'm able to get to the list with the tables in the PHPAdmin - "genealogi" the database is called, but I don't see the option Repair, how do I find it?

You have to execute it as an SQL query.

I have chosen Localhost - genealogi, do I then copy this

> repair table tng_families;

into the Sql Query window?

I didn't tell you that my Wamp is in Danish, this might make a difference regarding what you write in the SQL Query window. I'm a bit nervous that I might mess up things. I have seen in a tutorial for PHPAdmin that the SQL Query is for advanced users and that just one wrong letter or sign can do a lot of damage.

There's the other possibility, "Query via eks." (I don't understand" eks.", maybe it means example) but I don't know how to find the right Query in order to repair the families table.

yes just do that then press go.

I'm sorry, I had to take a break.

May I ask you once more, don't I put this in the SQL Query window:

repair table tng_families;

As I understand it, the sign > doesn't have to be there, wasn't that just in order to list, what I should do, like 1., 2. etc.?

I found a solution:

[php.about.com]

The families table was successfully repaired, now I can back up the table again and everything works fine.

Thanks a lot for giving me the clue to do a repair. :-)



Best regards
Vanda