vb.org Archive - MySQL troubles, error on ALTER queries...

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - MySQL troubles, error on ALTER queries... (https://vborg.vbsupport.ru/showthread.php?t=55063)

Link14716

07-06-2003 09:20 PM

MySQL troubles, error on ALTER queries...

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:

Code:

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.

All times are GMT. The time now is 06:39 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01210 seconds Memory Usage 1,711KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: