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

Page 45 of 87

« First

Last »

Show 40 post(s) from this thread on one page

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)

Sidewindr

12-08-2006 03:32 AM

Quote:

Originally Posted by hotwheels (Post 1133817)

I really only hooked myself up bro, with the bogus profile field entries, and for months nobody helped to jump in and put the correct alter field in the .xml........I said from the beginning when i shared how i did it, that i am "no coder"........Funny thing is though, over 50 people used my bogus way into the 2 huge profile field entries, which was pretty tough to do, since all you have to do is run 2 queries........it may cause arthritis in your finger's having to cut and paste and click run.......whew.

and as stated here. "I am no coder"......

Yeah I know dude .. I was not having a go at you .. :) It's all good .. I was just saying you don't need to create the bogus (bogus to vbulletin as the descriptions moved not to us) profile fields with the latest update from deathemperor. Don't be so defensive ;)

Sidewindr

12-08-2006 03:35 AM

Quote:

Originally Posted by zincpony (Post 1133878)

UGHHH it wont let me uninstall via the plug in manager, how can i remove it manually. i already reverted the styles and replaced image, member and the includes php files. how can i remove the xmls and database addition

To uninstall you need to revert the template changes, remove the custom profile fields as well as drop the customfile table.

Sidewindr

12-08-2006 03:37 AM

Quote:

Originally Posted by hotwheels (Post 1133978)

I didn't see any uninstall code inside this https://vborg.vbsupport.ru/attachmen...4&d=1165477590

Yeah there is ... Line 124-129

Code:

                        <uninstallcode><![CDATA[        $db->query_write("DROP TABLE " . TABLE_PREFIX . "customfile");

        $db->query_write("ALTER TABLE `" . TABLE_PREFIX . "user` DROP `tdban` ");

        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` IN(51,52,53,54,55,56,57,58,59,60,61,62,63,64,65)");

        $db->query_write("ALTER TABLE `" . TABLE_PREFIX . "userfield` DROP `field50`,        DROP `field51`, DROP `field52`, DROP `field53`, DROP `field54`, DROP `field55`, DROP `field56`, DROP `field57`, DROP `field58`, DROP `field59`, DROP `field60`, DROP `field61`, DROP `field62`, DROP `field63`, DROP `field64`, DROP `field65`");

        $db->query_write("OPTIMIZE TABLE " . TABLE_PREFIX . "userfield");

        build_hiddenprofilefield_cache();]]></uninstallcode>

deathemperor

12-08-2006 03:45 AM

For the new installations and upgrade on vb3.6, I've tested both and they were working fine. I would not suggest you upgrade from the modified version of hotwheels.

Perhaps I missed the brand new installation test on vb3.6 but I'm sure the upgrade was fine.

For zincpony, are you sure you downloaded the right zip ? Timeslip 3.6 v1.2.zip is for vb3.6 while the other is not. If you downloaded Timeslip 3.5 v1.1.4.zip and install it in a 3.6 forum, the errors "missing title" will be generated. This is because from 3.5 to 3.6, they change the title of the profilefields into phrases (so that you can translate into other langs). As a result of that is the "title" column is removed from table profilefield => old queries of the Timeslip hack does not work. I modified all quries, so if you got that error I think you installed the Timeslip 3.5 v1.1.4.zip version.

Also, in the version 1.2 of Timeslips, the code

PHP 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))");
        $db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD tdban smallint(5) unsigned DEFAULT 1 NOT NULL");
  ]]>

will be ran in any condition of a new installation.

My mistake here: I included the product-timeslips.xml in the zip, don't use that file, use product-timeslips1.2.xml.

I believe the file product-timeslips.xml is the reason why zincpony was getting errors, I removed it from the zip above. for those that used product-timeslips.xml, just import product-timeslips1.2.xml choose overwrite (or something like that)

Sidewindr

12-08-2006 03:52 AM

Quote:

Originally Posted by deathemperor (Post 1134302)

For the new installations and upgrade on vb3.6, I've tested both and they were working fine. I would not suggest you upgrade from the modified version of hotwheels.

Perhaps I missed the brand new installation test on vb3.6 but I'm sure the upgrade is fine.

For zincpony, are you sure you downloaded the right zip ? Timeslip 3.6 v1.2.zip is for vb3.6 while the other is not. If you downloaded Timeslip 3.5 v1.1.4.zip and install it in a 3.6 forum, the errors "missing title" will be generated. This is because from 3.5 to 3.6, they change the title of the profilefields into phrases (so that you can translate into other langs). As a result of that is the "title" column is removed from table profilefield => old queries of the Timeslip hack does not work. I modified all quries, so if you got that error I think you installed the Timeslip 3.5 v1.1.4.zip version.

Also, in the version 1.2 of Timeslips, the code

PHP 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))");

        $db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD tdban smallint(5) unsigned DEFAULT 1 NOT NULL");

  ]]>

did you review the changes I made in the 1.2.1 I posted earleir which added checks for the upgrade process .. I had to do this as the upgrade failed for me.

deathemperor

12-08-2006 04:17 AM

The upgrade was fine for me. Because: if you import the xml file again, vbulletin won't check for changes in installation codes instead it will check for code of newer version and replace all plugins, templates, phrases etc. As of right now I don't think your code is important, I will test it again this weekend.

zincpony

12-08-2006 04:22 AM

im getting that problem now,

missing title field, i tried to reupload the XML file you recommended and it didnt fix it. everytime i click on user name to view their profile i get an database error.

Code:

Invalid SQL:



SELECT profilefieldid, required, title, type, data, def, height

FROM profilefield

WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND form = 0 

ORDER BY displayorder;



MySQL Error  : Unknown column 'title' in 'field list'

Error Number : 1054

deathemperor

12-08-2006 04:34 AM

can I have a link to the timeslips of yours ?

zincpony

12-08-2006 05:01 AM

<a href="http://boostedmustangforums.com/timeslips.php?" target="_blank">http://boostedmustangforums.com/timeslips.php?</a>

click on either my name Zincpony or GT-Eaters or click on details. and another thing i've noticed is that the field where you enter car type is gone. click on any name on the forum and try to view any members profiles none will work

deathemperor

12-08-2006 05:27 AM

Can you reimport the xml product file and choose replace ?

if that doesn't work, please try reinstall it by running the following queries:

[mysql] DELETE FROM `profilefield` WHERE `profilefieldid` IN(51,52,53,54,55,56,57,58,59,60,61,62,63,64,65)
ALTER TABLE `userfield` DROP `field50`, DROP `field51`, DROP `field52`, DROP `field53`, DROP `field54`, DROP `field55`, DROP `field56`, DROP `field57`, DROP `field58`, DROP `field59`, DROP `field60`, DROP `field61`, DROP `field62`, DROP `field63`, DROP `field64`, DROP `field65`
OPTIMIZE TABLE userfield
[/mysql]
one line a time

after that reinstall the hack.

All times are GMT. The time now is 08:36 PM.

Page 45 of 87

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03083 seconds Memory Usage 1,766KB 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 (2)bbcode_code_printable (2)bbcode_php_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: