vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   my site is down due to mysql error 1030 (https://vborg.vbsupport.ru/showthread.php?t=103889)

Marco van Herwaarden 12-28-2005 02:19 PM

Error 127 is not because of a missing table prefix.

arashjaf 12-28-2005 05:10 PM

Quote:

Originally Posted by Revpolar
You are right but if he can login there then the tables are ok. Because those tables are required to login.

I seem to be confussing someone. So let me start over. He says e has run repair tables from within admincp. To do that he had to login to th admincp. If his database tables for user fields wee really bad then he would not be able to login to the admincp. So what Im trying to say is that I think (speculate r guess) that he has installed some hack that is missing the Table_prefix from its code. And his database is installed with a table prefix. Therefore when that hack queries te database it doesnt look for the table prefix in the config so he get an error because there is no such table user instead it should be table PMA_user.
Uninstall hacks one at a time until you figure out which one causes the error is my recommendation.
Sorry for the confusion.

no i can't login to vb admin, as son as i give my username and pass it gives me the same error for the site, and i haven't installed anything.

the last thing i did was to password protect some of my folders, like log folder in my root directory. and i made them public just like the way they were from the stat.

i did the repair in my host control panel not from vb as i can't get into vb admin

Marco van Herwaarden 12-28-2005 05:16 PM

If you can not solve it, you could try opening a support ticket at vb.com.

Paul M 12-28-2005 05:32 PM

Your user table is broken, as shown when you try and login to the admincp ;

Quote:

ERROR: Database error.
Cannot execute the query: SELECT userid, username FROM user ORDER BY userid DESC LIMIT 1
MySql Error returned: Got error 127 from storage engine
MySql Error code: 1030

arashjaf 12-28-2005 05:41 PM

Quote:

Originally Posted by MarcoH64
If you can not solve it, you could try opening a support ticket at vb.com.


thank you all
it is working now

madramper 03-21-2007 01:11 AM

I am having the same problem right now. How did you resolve this issue?

Quote:

Originally Posted by Paul M (Post 858753)
Your user table is broken, as shown when you try and login to the admincp ;

How do you fix a broken user table?

Marco van Herwaarden 03-21-2007 08:53 AM

Please post the exact error message you are getting.


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01151 seconds
  • Memory Usage 1,728KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete