Member Log In
Site Navigation
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
![]() |
| | #1 | ||||||||
| vB Newbie
![]() |
Status: Offline 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 | ||||||||
| |
| | #2 | |||||||||
Location: Israel Age: 29 ![]() |
Status: Offline 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 | |||||||||
|
| | #3 | ||||||||
| vB Newbie
![]() |
Status: Offline 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 | ||||||||
|
| | #4 | |||||||||
Location: Israel Age: 29 ![]() |
Status: Offline 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: 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. | |||||||||
|
| | #5 | ||||||||
| vB Newbie
![]() |
Status: Offline 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 | ||||||||
|
| | #6 | |||||||||
Location: Israel Age: 29 ![]() |
Status: Offline 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. 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 | |||||||||
|
| | #7 | |||||||||
| vB Newbie
![]() |
Status: Offline Quote:
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" | |||||||||
|
| | #8 | ||||||||||
Location: Israel Age: 29 ![]() |
Status: Offline Quote:
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 | ||||||||||
|
![]() |
| Thread Tools | |
| |
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:51 AM.
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.




















