View Single Post
  #794  
Old 03-24-2006, 07:16 AM
Borisch Borisch is offline
 
Join Date: Mar 2002
Location: Sweden
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hey,

I've been trying to get this one working all night but to no avail. All the files have been uploaded correctly and the templates have been changed accordingly. The problem is when installing the xml file. It seems as though none of the tables are created. At first I figured that it might be so that it stops on some SQL (ie a table already exists) and doesn't resume. However, this happens even if I make sure that there are no offending tables and columns in the database.

So I tried creating the tables and columns manually by simply executing the sql that the installation is supposed to take care of. However, this doesn't help since I still can't warn anyone. I get errors that the column doesn't exist.

Here is an excerpt of errors I get:

This is what I get when trying to warn someone:
Code:
Database error in vBulletin 3.5.3:
 
Invalid SQL:
update user set warning_level='4', warnings='1' where userid='111';
 
MySQL Error  : Unknown column 'warnings' in 'field list'
This is what I get when trying to view some statistics in the control panel:
Code:
Database error in vBulletin 3.5.3:
 
Invalid SQL:
SELECT COUNT(*) AS users FROM user AS user where warnings>0 OR alerts>0;
 
MySQL Error  : Unknown column 'warnings' in 'where clause'
And so on and so forth. Now, some things works. I can add different warning types and change options and such. But I have no idea where this values are saved. If I create a warning type, it's not saved in the warning_types table as it is completely empty at all times. Even searching for the warning type in the database turns up empty. It's very strange and I have no idea what might be causing this. Has anyone else experienced these kinds of issues and been able to solve them somehow?

As can be seen from the error messages, I'm running vB 3.5.3. I'm also using the latest files posted in this thread.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01177 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete