View Single Post
  #429  
Old 12-07-2006, 05:49 PM
TurboLaserAWD TurboLaserAWD is offline
 
Join Date: Dec 2005
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by hotwheels View Post
I didn't see any uninstall code inside this https://vborg.vbsupport.ru/attachmen...4&d=1165477590

If you don't mind, give me a look at your phpmyadmin, so we can see where the code is that's hanging up........it look's to be in "user", "tban"......but i don't have the error's and zincpony had to leave for a while.......he too, still can't uninstall the previous .xml, it is going to have to be done manually at this point.......Let me know if you need assistance, i will gladly try to help ya out, but sad to say, i will need access to your phpmyadmin, to help.
That second file looks like it was meant to be some kind of ammendment to the original. I'm starting with this code here to manually add the "customfile" field. The syntax is wrong in the SQL which is why it's not being created.

Code:
$db->query_write("CREATE TABLE " . TABLE_PREFIX . "customfile (
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    filedata MEDIUMTEXT NOT NULL,
    dateline INT UNSIGNED NOT NULL DEFAULT '0',
    filename VARCHAR(100) NOT NULL DEFAULT '',
    visible SMALLINT NOT NULL DEFAULT '1',
    filesize INT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (userid))");
I'm getting the following error message in phpMyAdmin:

Quote:
Originally Posted by phpMyAdmin
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 4
STR: ->
SQL: $db->query_write("CREATE TABLE " . TABLE_PREFIX . "customfile ( userid INT UNSIGNED NOT NULL DEFAULT '0', filedata MEDIUMTEXT NOT NULL, dateline INT UNSIGNED NOT NULL DEFAULT '0', filename VARCHAR(100) NOT NULL DEFAULT '', visible SMALLINT NOT NULL DEFAULT '1', filesize INT UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (userid))")

SQL query:

$db->query_write("CREATE TABLE " . TABLE_PREFIX . "customfile ( userid INT UNSIGNED NOT NULL DEFAULT '0', filedata MEDIUMTEXT NOT NULL, dateline INT UNSIGNED NOT NULL DEFAULT '0', filename VARCHAR(100) NOT NULL DEFAULT '', visible SMALLINT NOT NULL DEFAULT '1', filesize INT UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (userid))")

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$db->query_write("CREATE TABLE " . TABLE_PREFIX . "customfile (
userid INT UNS' at line 1
Maybe you can start there.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02022 seconds
  • Memory Usage 1,779KB
  • 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
  • (1)bbcode_code
  • (2)bbcode_quote
  • (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