Thread: DataBase Error
View Single Post
  #7  
Old 01-27-2009, 05:58 PM
Ahmet Turan Ahmet Turan is offline
 
Join Date: Dec 2006
Location: Mersin
Posts: 115
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Step first full
step two not complete ( that db problem )
and not try again

--------------- Added [DATE]1233090366[/DATE] at [TIME]1233090366[/TIME] ---------------

try again
PHP Code:
Step 2Table Data Updates

    
Altering poll Table (1 of 1)
    * 
Altering calendarcustomfield Table (1 of 1)
    * 
Altering usergroup Table (1 of 1)
    * 
Altering moderator Table (1 of 1)

Database Error     Database error
The 
..:: WeBiLGi ::.. database has encountered a problem.
Please try the following:

    * 
Load the page again by clicking the Refresh button in your web browser.
    * 
Open the www.webilgi.com home pagethen try to open another page.
    * 
Click the Back button to try another link.

The www.webilgi.com forum technical staff have been notified of the errorthough you may contact them if the problem persists.
 
We apologise for any inconvenience.
Database error in vBulletin 3.6.8Invalid SQLUPDATE moderator SET permissions2 permissions2 | IF(permissions 1327680) | IF(permissions 281920) | IF(permissions 131072163840) | IF(permissions 6440960); MySQL Error Unknown column 'permissions2' in 'field list' Error Number 1054 Request Date TuesdayJanuary 27th 2009 11:04:48 PM Error Date TuesdayJanuary 27th 2009 11:04:48 PM Script http://www.webilgi.com/install/upgrade_370b4.php?step=2 Referrer : http://www.webilgi.com/install/upgrade_370b4.php?step=1 IP Address : 78.188.14.90 Username : Classname : vb_database MySQL Version : 5.0.67-community

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE moderator SET
            permissions2 
permissions2 |
                IF(
permissions 1327680) |
                IF(
permissions 281920) |
                IF(
permissions 131072163840) |
                IF(
permissions 6440960);

MySQL Error   Unknown column 'permissions2' in 'field list'
Error Number  1054
Request Date  
TuesdayJanuary 27th 2009 11:04:48 PM
Error Date    
TuesdayJanuary 27th 2009 11:04:48 PM
Script        
http://www.webilgi.com/install/upgrade_370b4.php?step=2
Referrer      http://www.webilgi.com/install/upgrade_370b4.php?step=1
IP Address    78.188.14.90
Username      

Classname     vb_database
MySQL Version 
5.0.67-community 
--------------- Added [DATE]1233132297[/DATE] at [TIME]1233132297[/TIME] ---------------

--------------- Added [DATE]1233132346[/DATE] at [TIME]1233132346[/TIME] ---------------

Fisrt db Error
PHP Code:
Step 2Table Data Updates

    
Altering poll Table (1 of 1)
    * 
Altering calendarcustomfield Table (1 of 1)
    * 
Altering usergroup Table (1 of 1)
    * 
Altering moderator Table (1 of 1)

Database Error     Database error
The 
..:: WeBiLGi ::.. database has encountered a problem.
Please try the following:

    * 
Load the page again by clicking the Refresh button in your web browser.
    * 
Open the www.webilgi.com home pagethen try to open another page.
    * 
Click the Back button to try another link.

The www.webilgi.com forum technical staff have been notified of the errorthough you may contact them if the problem persists.
 
We apologise for any inconvenience.
Database error in vBulletin 3.6.8Invalid SQLUPDATE moderator SET permissions2 permissions2 | IF(permissions 1327680) | IF(permissions 281920) | IF(permissions 131072163840) | IF(permissions 6440960); MySQL Error Unknown column 'permissions2' in 'field list' Error Number 1054 Request Date TuesdayJanuary 27th 2009 11:04:48 PM Error Date TuesdayJanuary 27th 2009 11:04:48 PM Script http://www.webilgi.com/install/upgrade_370b4.php?step=2 Referrer : http://www.webilgi.com/install/upgrade_370b4.php?step=1 IP Address : 78.188.14.90 Username : Classname : vb_database MySQL Version : 5.0.67-community

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE moderator SET
            permissions2 
permissions2 |
                IF(
permissions 1327680) |
                IF(
permissions 281920) |
                IF(
permissions 131072163840) |
                IF(
permissions 6440960);

MySQL Error   Unknown column 'permissions2' in 'field list'
Error Number  1054
Request Date  
TuesdayJanuary 27th 2009 11:04:48 PM
Error Date    
TuesdayJanuary 27th 2009 11:04:48 PM
Script        
http://www.webilgi.com/install/upgrade_370b4.php?step=2
Referrer      http://www.webilgi.com/install/upgrade_370b4.php?step=1
IP Address    78.188.14.90
Username      

Classname     vb_database
MySQL Version 
5.0.67-community 
solution (to a problem)
PHP Code:
alter table `moderatoradd `permissions2int(10unsigned NOT NULL default '0'

Secondes DB Error
PHP Code:
Database error in vBulletin 3.8.0:

Invalid SQL:

SELECT forum.forumidlastpostlastposterlastthreadlastthreadidlasticonidthreadcountreplycountlastpostidlastprefixid

FROM forum 
AS forum;

MySQL Error Unknown column 'lastprefixid' in 'field list'
Error Number 1054
Request Date 
WednesdayJanuary 28th 2009 09:17:54 AM
Error Date 
WednesdayJanuary 28th 2009 09:17:56 AM
Script 
: ..:: WeBiLGi ::.. Database Error
Referrer 
webilgi Google'da Ara
IP Address : 78.188.14.90
Username : prAmid
Classname : vb_database
MySQL Version : 5.0.67-community 
solution (to a problem)
PHP Code:
alter table `forumADD  `lastprefixidvarchar(25NOT NULL default ''
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01160 seconds
  • Memory Usage 1,865KB
  • 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
  • (5)bbcode_php
  • (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