Follow vBSEO on Twitter
vBulletin Modifications
  • Forums
  • Add-Ons
  • Template Modifications
  • Styles
  • Graphics
  • Tutorials
  • Support Center
  • Register
  • vBulletin SEO

Member Log In

Site Navigation

  • Register
  • Members List
  • Social Groups
  • Search
  • Today's Posts
  • Mark Forums Read

Latest Modifications

  • [vB 3.8.4] THX - Hack for VB. 3.8.4
    By: bluedog
  • [vB 3.8.4] Cyb - Chatbox V.2.3
    By: bluedog
  • [vB 4.0.x] PHPKD - Advanced Quick...
    By: PHPKD
  • [vB 3.6.x] StopSpam
    By: flappi282
  • [vB 3.8.x] vBulletin Chat Addon for...
    By: 123flashchat

Latest Template Mods

  • [vB 4.0.x] Remove My Profile Link...
    By: Ak Worm
  • [vB 3.8.x] Images DownloadBox...
    By: cRs!MP
  • [vB 3.8.x] Adviertise Mod On Forum...
    By: MG4
  • [vB 3.8.4] Images PassWordBox...
    By: cRs!MP
  • [vB 3.8.4] Footer Follow Ups
    By: Ak Worm

Latest Styles

  • [vB 4.0.x] 4.0.3 - VB4STYLE-TWEETA...
    By: Belon
  • [vB 4.0.x] [4.0.3] vbdesigns.de...
    By: Belon
  • [vB 3.8.4] CompletevB - Skylight
    By: DreadKnight
  • [vB 3.8.3] [vB 3.8.4] Barcelona...
    By: hoiquantinhoc.com
  • [vB 3.8.3] Natures Walk by vBSkin...
    By: Chri5

Latest Graphics

  • [vB ] [anim.]Team Ranks
    By: cRs!MP
  • [vB ] Abstract Circles (3...
    By: cRs!MP
  • [vB ] PlayStation Rank Images
    By: cRs!MP
  • [vB 3.6.12] Heavy Stroked Button...
    By: Shelley
  • [vB ] Minature Ranks.
    By: Shelley
vBulletin Modifications » Support Center » vBulletin Support » data base error Table 'aaa3d.administrator' doesn't exist
Reply

 

  • Thread Tools
Old 06-27-2009, 06:50 PM   #1
artinjulio
vB Newbie

Activity Longevity
0/20 4/20
Today Posts
0/3 ssssssss5
artinjulio is on a distinguished road
Status: Offline Default data base error Table 'aaa3d.administrator' doesn't exist
Hello, can you help me with this

thank, and not speak english , but is ok
<!--
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_cphome AS phrasegroup_cphome,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 1;

MySQL Error : Table 'aaa3d.administrator' doesn't exist
Error Number : 1146
Date : Saturday, June 27th 2009 @ 01:56:59 PM
Script : REMOVED by Idan
Referrer : REMOVED by Idan
IP Address : 190.245.64.135
Username :
Classname : vb_database

EDITED by Idan:
Removed link to your site admincp !

Last edited by Idan; 06-27-2009 at 07:19 PM. Reason: removed admincp link
Reply With Quote My Problem Was Solved :)
Old 06-27-2009, 07:21 PM   #2
Idan
Coder
Idan's Avatar

Activity Longevity
0/20 18/20
Today Posts
0/3 sssss1484
Location: Israel
Age: 29
Idan is on a distinguished road
Status: Offline Default
looks as if you are missing critical vbulletin table on your database.
Have you deleted this table manaully ?
Regards,
Idan.

* Support will only be given via forums !
* If this post solved/aided your problem, please click "mark as aid" / "mark as solution" as explained in here
Reply With Quote
Old 06-27-2009, 07:36 PM   #3
artinjulio
vB Newbie

Activity Longevity
0/20 4/20
Today Posts
0/3 ssssssss5
artinjulio is on a distinguished road
Status: Offline Default
no i dont delete that table

But why the error say aaa3d(my domain).administrator like the aaa3d is a sufix? the tables for my vbulletin DON't have any sufix

the database name is aaa3d but not sufix for vbulletin
Reply With Quote
Old 06-27-2009, 07:45 PM   #4
Idan
Coder
Idan's Avatar

Activity Longevity
0/20 18/20
Today Posts
0/3 sssss1484
Location: Israel
Age: 29
Idan is on a distinguished road
Status: Offline Default
it isnt a suffix, that's the database name.

EDIT:
I'm not sure if there is any tool that allows to reconstruct this table.

EDIT2:
I'm attaching screenshot of the table strcture, try to add it manually via some tool such as phpmyadmin:
Solution to original question
Regards,
Idan.

* Support will only be given via forums !
* If this post solved/aided your problem, please click "mark as aid" / "mark as solution" as explained in here

Last edited by Idan; 06-27-2009 at 07:54 PM.
Reply With Quote
Old 06-27-2009, 08:08 PM   #5
artinjulio
vB Newbie

Activity Longevity
0/20 4/20
Today Posts
0/3 ssssssss5
artinjulio is on a distinguished road
Status: Offline Default
ok thank so much

one thing, you say me the are isn;t a sufix.
is the NAME of the database?
so what the name of the table i will create?
aaa3d.administrator o administrator only? (i dont know much abaut mysql sorry)


But i dont have any other tables whit that aaa3d.xxxxxx

look
Reply With Quote
Old 06-27-2009, 08:16 PM   #6
Idan
Coder
Idan's Avatar

Activity Longevity
0/20 18/20
Today Posts
0/3 sssss1484
Location: Israel
Age: 29
Idan is on a distinguished road
Status: Offline Default
table name should be "administrator", no suffix.

After you create it, add to it new row with master admin user id (usually "1").
Under the "adminpermissions" field i have (on my personal test forum) "491516".

hope this helps.
Solution to original question
Regards,
Idan.

* Support will only be given via forums !
* If this post solved/aided your problem, please click "mark as aid" / "mark as solution" as explained in here
Reply With Quote
Old 06-27-2009, 09:27 PM   #7
artinjulio
vB Newbie

Activity Longevity
0/20 4/20
Today Posts
0/3 ssssssss5
artinjulio is on a distinguished road
Status: Offline Default
Quote:
Originally Posted by Idan View Post
table name should be "administrator", no suffix.

After you create it, add to it new row with master admin user id (usually "1").
Under the "adminpermissions" field i have (on my personal test forum) "491516".

hope this helps.

ok Its WORK AGAIN thank

one think, you say me add a ROW with master admin user id
but i cant create on administrator table a new row with that name "master admin user id"
Reply With Quote
Old 06-28-2009, 05:05 AM   #8
Idan
Coder
Idan's Avatar

Activity Longevity
0/20 18/20
Today Posts
0/3 sssss1484
Location: Israel
Age: 29
Idan is on a distinguished road
Status: Offline Default
Quote:
Originally Posted by artinjulio View Post
ok Its WORK AGAIN thank

one think, you say me add a ROW with master admin user id
but i cant create on administrator table a new row with that name "master admin user id"
i didnt mean add field with any "name" like "master admin user id", just meant fill the user id of the administrator, and even mentioned it's usually "1". i added "master" description since you could have several administrator on that site.

anyway, glad everything works again.
Regards,
Idan.

* Support will only be given via forums !
* If this post solved/aided your problem, please click "mark as aid" / "mark as solution" as explained in here
Reply With Quote

Reply

« Help with errors :( | How can I have this template? »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Rules

Similar Threads
Thread Thread Starter Forum Replies Last Post
Integrating AJAX Technology Into Your Modifications Zero Tolerance vBulletin Modification Tutorials 3 08-28-2006 01:30 PM



All times are GMT. The time now is 05:25 AM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.
Transverse Styles
  • Top
  • Archive
  • vBSEO
  • Contact Us
LinkBack
LinkBack URL LinkBack URL
About LinkBacks About LinkBacks
Bookmark & Share
Digg this Thread! Digg this Thread!
Add Thread to del.icio.us Add Thread to del.icio.us
Bookmark in Technorati Bookmark in Technorati
Furl this Thread! Furl this Thread!