[Sun Sep 10 06:00:11 2000] nph-build.cgi: Can't find file: 'Build_Update.MYD' (errno: 2) at /home/Mottster/www/cgi-bin/admin/nph-build.cgi line 141.

Here's the section of code where this is happening:

--------------------------------------------
# Load the Build Update table definition, and update the counters.
$build_stats = new Links::DBSQL "$LINKS{admin_root_path}/defs/Build_Update.def";
$limit = 1000; $offset = 0;
$update_hits = $LINKDB->prepare (qq! UPDATE Links SET Hits = Hits + ? WHERE ID = ? !) or die $DBI::errstr;
$update_rate = $LINKDB->prepare (qq! UPDATE Links Set Votes = Votes + ?, Rating = ((Rating*(Votes-?))+?)/Votes WHERE ID = ?!) or die $DBI::errstr;
--------------------------------------------

Anyone have any idea on why this error message is coming up? Everything was working just fine, and then this.. Already searched the forums and no luck. I've verified that the Build_Update.def file is located in the exact path as listed.. I check my crontab file, I had accidently had two process occur at the sametime. But that has since been resolved.

Thanks,

Sean

Thanks,

Sean Mott
http://www.weathertalk.net
Internet's best weather search engine

Hi,

seems to be a problem with your mysql database. The file 'Build_Update.MYD' should have been built by setup.cgi.

Try to run setup.cgi again. Click on create tables ( tables already existing will not be affected) then build again.

hope it helps,
regards, alexander

Great thanks Alex404. It seems that something must of happened to my provider during the night. Because a few hours before this occurred everything was working great. So all my data will fine if I re run the setup?

When I telneted into my server and did a DESCRIBE Build_Update; it came up saying it couldn't find the Build_Update.MYD do I need to remove the Build_Update table? Just curious

Thanks,

Sean Mott
http://www.weathertalk.net
Internet's best weather search engine

Ok, I ran the Create Tables under the setup.cgi for LinksSQL. Here's the error I get:

Welcome to Links SQL Setup!
---------------------------
Creating tables ... (Mottster, xxxxxxx, )
Creating table Build_Update ... failed (already exists).
Loading def file from SQL ... failed (DBSQL (12280): Fatal Error: Unable to execute query: DESCRIBE Build_Update. Reason: Can't find file: 'Build_Update.MYD' (errno: 2) at /path/to/admin/setup/setup.cgi line 291)
Saving def file ... failed (Can't use an undefined value as a HASH reference at ../Links/DBSQL.pm line 1353.

Then when attempting to run nph-build.cgi this is the error that I get.

[Sun Sep 10 21:33:36 2000] nph-build.cgi: DBSQL (12218): Fatal Error: Error loading Config file '/path/to/admin/defs/Build_Update.def'. Reason: Parse Error: [Sun Sep 10 21:33:36 2000] nph-build.cgi: /path/to/admin/defs/Build_Update.def did not return a true value at
/path/to/admin/Links/DBSQL.pm line 1318.
[Sun Sep 10 21:33:36 2000] nph-build.cgi: at nph-build.cgi line 1


Also when I telnet and login to mySQL links database I get this message:
----------
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'Build_Update'
Database changed
----------

This also occurs after rerunning to Create Tables under setup.cgi. Could it be that my tables are corrupted? If so can it be fixed without loosing any data or links.?


Thanks,

Sean Mott
http://www.weathertalk.net
Internet's best weather search engine

Your best bet is to dump your data, and tables into separate files, then recreate them, re-import the data and see if it works.

You'll have your data.

You'll have your structure.

but, you can't use a corrupt database for any length of time, and all new data is at risk.

Use mysqlman and dump the structure only, you might have to do it table by table, if things are really corrupt.

Then, use mysqlman to dump the data, and write out the Insert statements, since if you recreate the tables, without the Insert statements you'll have to have the columns in the same order.



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Hello!

You can install phpMyadmin from www.phpwizard.net and check it out. You may try to re-create that table by first droping the same first. PhpMyadmin will help you in creating and changing the field values in an easy way which is most probably the problem area in your case.

Thanks to all who replied. I got in contact with Alex who resolved the issue: Here'a a brief explanation of what he did.

To fix, I had to manually drop and recreate the table, and then re-create the .def file.

I probably could of fixed this but was to worried about losing data. Again thanks to Alex for the fix to this issue.


Thanks,

Sean Mott
http://www.weathertalk.net
Internet's best weather search engine

Hmmm...isn't that what pugdog recommended???

Regards,

Eliot Lee