PDA

View Full Version : MySQL troubles, error on ALTER queries...


Link14716
07-06-2003, 09:20 PM
It seems that on some alter queries, I end up getting an error. I get it everywhere, from the vB3 admin center to phpMyAdmin.... The error looks something like this:

From vB3:
An error occured while attempting to execute your query. The following information was returned.
error number: 7
error desc: Error on rename of '.\vb3\shoutbox_posts.MYI' to '.\vb3\#sql2-854-12.MYI' (Errcode: 13)

EDIT: Nevermind, phpMyAdmin took this one. Sometimes I get the error im phpMyAdmin and can get it to work in vB3, sometimes it's the other way around I guess...

EDIT2: Now I have another query that is putting an error, but it won't work anywhere... help?

Dark_Wizard
07-07-2003, 11:54 AM
It appears you are running vb3 and using the shoutbox hack...vb3 is in beta and hacks aren't supported here yet.

Link14716
07-07-2003, 04:42 PM
Actually, I am creating a shoutbox hack, and I was altering the table. For the record, before I starting doing any hacks, I still got an error similar to that on a lot of alter queries.

Either way, the error has nothing to do with vB3, it has to do with MySQL ++++ing up.

noppid
07-07-2003, 04:56 PM
Why would you attempt to build a hack on an unstable board?

I was hoping to help, but since you said you started with errors, I think the answer is obvious... Start with stable code.

Link14716
07-07-2003, 05:01 PM
What, you want me to re-install MySQL or something? vB3 has nothing to do with it, neither does PHP. I can put an ALTER code in to any program written in any programming language and get the same error.