vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Table doesn't exist anymore (https://vborg.vbsupport.ru/showthread.php?t=169635)

Lord Zedd 02-04-2008 03:00 PM
Table doesn't exist anymore
 
Hello,

I am looking for some help. I'll try to explain my situation. I was able to establish a succesfull bridge between Joomla 1.012 and Vbulletin 3.6.0. No problems at all. The login worked fine.
Three days ago I decided to upgrade Joomla to 1.5 stable version. It was succesfull. But because of that the login from vbulletin doesn't not work now anymore. Now no member can log in anymore. What can I do about that? I don't get any help from the Joomla community or where I bought the bridge from. So I really hope anyone of you can help me out please? It says the table users doesnt' exist and it is right. The migration from Joomla 1.0 to 1.5 was succesfull. It even transfered the members. I also have a database backup from a little while back. Any help is much appreciated.

PHP Code:
Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM users
WHERE LOWER(username)='anubis'
LIMIT 1;

MySQL Error : Table 'stargate.users' doesn't exist
Error Number : 1146
Date : Sunday, February 3rd 2008 @ 09:42:38 PM
Script : http://www.XXXXXX.com/forum/login.php?do=login
Referrer : http://www.XXXXXX.com/forum/admincp/index.php
IP Address :
Username : Anubis 
Classname : vb_database

nexialys 02-04-2008 03:05 PM
you need to know the TABLE_PREFIX in your installation to be able to connect to that table... it is not deleted, it is just not identicated properly.

Lynne 02-04-2008 04:09 PM
Are you sure that query is correct? vbulletin has a "user" table, but not a "users" table. Maybe change that query to say "user" and not "users".

(If you do have a "users" table also, then disregard my post. I actually do have both because I have a tracker integrated into my site and it uses a "users" table.)

nexialys 02-04-2008 04:13 PM
actually, this query comes from the Joomla integration...


All times are GMT. The time now is 11:18 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.01607 seconds
  • Memory Usage 1,714KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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