PDA

View Full Version : MySQL Database Problems


infrenion
06-30-2003, 03:07 AM
Hello !

I've been getting some MySQL database errors:


There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser. An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologize for any inconvenience.

What could be wrong? I was just monitoring my website's traffic when the error came up. Anyone knows what to do???

Thanks,
Jeremy
valkster
06-30-2003, 06:26 AM
Try repairing your database via PHPmyadmin. This should hopefully fix this issue!
infrenion
06-30-2003, 06:42 AM
Hi!

Thanks for that tip.

I was trying to have it repaired when this error shows up:

SQL-query :

SHOW KEYS FROM `userlogin`

MySQL said:


Can't open file: 'userlogin.MYI'. (errno: 145)

What should be my next step? :(

And how did this problem happen?

Thanks,
Jeremy
valkster
06-30-2003, 07:09 AM
Umm, Support??

What is THAT file??
TurnkeyAdmin
06-30-2003, 01:02 PM
Under any table hit the SQL link and type this into the SQL box.

"REPAIR TABLE userlogin"

if you have table prefixes use:

"REPAIR TABLE yourprefix_userlogin"
apollo
09-14-2003, 06:23 PM
I have an ASP installation, and had to run this repair command on several clients.

Why does this happen?

Can anything be done to prevent these errors from happening?

Would it be okay to run this command regularly through a cron job?
TurnkeyAdmin
09-14-2003, 11:51 PM
The issues seems to be a server issue as far as we can tell so far. Its basically something that happens to the server that causes the files to get damaged.

Running the cron wont hurt anything as far as I know.
pwd
09-16-2003, 01:05 PM
I've been dealing with these errors every since buying this program. Support blamed it on my host, ipowerweb. Is there a way to turn off the notification so I don't log on to my email holding 1000+ error emails? Better yet can it be set to just send 1 error email?

Also when is the new version coming out? Over a month ago it was coming out "in a couple of weeks".

Thanks.
TurnkeyAdmin
09-16-2003, 03:16 PM
Um, you are mistaken on that. The new version isnt scheduled until next month. You must have mistaken the release for something else.

At any rate open the db_mysql.php and scroll to the bottom where it says "mail(...". Put "//" in front of that line.
pwd
09-16-2003, 04:43 PM
On 08-02-2003 at 10:15 PM you replied to the new version:

No word yet... we are trying to wrap it up within the next week or two. We had to get the SunShop 3.2 released before we continued the development.


__________________
Regards,
Turnkey Web Tools
support@turnkeywebtools.com



That is where I got my info from....
TurnkeyAdmin
09-17-2003, 03:06 AM
That is refering to the WinApp. Please see the post in context. Thank You.
pwd
09-17-2003, 04:59 AM
OK then. Where can we download the WinApp from? I don't see it anywhere.....
apollo
09-19-2003, 06:08 AM
Originally posted by TurnkeyAdmin
Under any table hit the SQL link and type this into the SQL box.

"REPAIR TABLE userlogin"

if you have table prefixes use:

"REPAIR TABLE yourprefix_userlogin"

Does this have the same effect as clicking on the Optimize Database button within the PHPLivehelper admin panel?
TurnkeyAdmin
09-19-2003, 02:44 PM
No optimizing is something different. Not related to repair.
pwd
09-22-2003, 02:25 AM
Originally posted by pwd
OK then. Where can we download the WinApp from? I don't see it anywhere.....
TurnkeyAdmin
09-22-2003, 04:31 AM
Not available yet. Please see the same post for more information.