vb.org Archive - vB Timeslip Database - for Automotive websites

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - vB Timeslip Database - for Automotive websites (https://vborg.vbsupport.ru/showthread.php?t=110717)

fkatzenb, yours looks fine bro..........seem's like everything is working right?

nevermind fkatzenb, yours isn't fine..........I noticed you don't have any of the lettering for your timeslips submit info......

Quote:

Originally Posted by hotwheels (Post 1133884)

nevermind fkatzenb, yours isn't fine..........I noticed you don't have any of the lettering for your timeslips submit info......

Ya, I am scared to try the updates until I have a good concept of what is going on. It is the vb3.5 version of timeslips. By the way, thanks for taking the time to look at this and even creating an account to help troubleshoot.

Frank

not a problem man, right now i am working with zincpony.........once i am done there, i will try to help ya out.....

I am having the same problem as zincpony so a resolution soon would be great. I can't overwrite the product-timeslips.xml to the product-timeslips1.2.xml without a database error (same ones). I also can't uninstall the product-timeslips.xml. And as of now, following all the instructions, I get a database error when I click the Timeslips links in the navbar.

hey frank (fkatzenb), i stopped by your site to help, but didn't see ya online there......do me a quick favor if you get this note and go to your severs phpmyadmin, and open up "profilefield", and then click on browse toward's the top of the page.......let me know what it say's in there for fields, 64,60,61,62,63, etc............or tell me if those are even in there....

later hotwheels...... you can shoot me an email or a pm if you would like......your's should be an easy fix.

Quote:

Originally Posted by TurboLaserAWD (Post 1133969)

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.

Quote:

Originally Posted by hotwheels (Post 1133978)

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.

If you compare the old version to the new version:

(3.6 new version) $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))");

(3.5.4 old version) $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))");

That part of the query is exactly the same, accept for the if(!$check['customfile']) just above that part of the 3.6 version, which was just added...

comparing the 2 .xml's side by side,

there are: 43 lines added, 129 lines modified, and 85 lines deleted.......

So that is a fairly big change for the .xml, i haven't compared the rest of the .php's in the new file yet.

X vBulletin 3.8.12 by vBS Debug 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_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01449 seconds Memory Usage 1,753KB 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_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: