vb.org Archive
Page 44 of 87 « First 344243 44 454654 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)

TurboLaserAWD 12-07-2006 06:48 PM
If I could just get that customfile table to be added I think I'd be okay. At least for that portion.

hotwheels 12-07-2006 06:52 PM
If you figure it out bro, please feel free to share, so that those wanting to upgrade to the 3.6 version that was just uploaded, can use it......

I have my site running and can't upload this new .xml........I just don't feel like trouble shooting on my site right now.......Since the hacking of my database, it is runnin pretty smoothly right now.........hehehehe

fkatzenb 12-07-2006 07:37 PM
Quote:
Originally Posted by hotwheels (Post 1133976)
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.
50 thru 65 exist. 63-65 are arrays... a:3:{etc...}

TurboLaserAWD 12-07-2006 07:44 PM
Alright I made some headway but I'm having problems with the $vbphrase. Here's what I did to correct my problem. I couldn't get rid of the old XML file because the SQL wouldn't let it finish. The problem was that it was trying to remove a table that wasnt there. So I simply took the lines out.

Everything highlighted is what I deleted from the XML and then I saved the file and re-uploaded it.

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

  ]]>
  </installcode>
- <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` = '50' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '51' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '52' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '53' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '54' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '55' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '56' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '57' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '58' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '59' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '60' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '61' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '62' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '63' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '64' LIMIT 1");
        $db->query_write("DELETE FROM `" . TABLE_PREFIX . "profilefield` WHERE `profilefieldid` = '65' LIMIT 1");
        $db->query_write("ALTER TABLE `" . TABLE_PREFIX . "userfield` 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`");
I had to change "field51" to "field52" and then delete the whole line that has "field52". This may or may not apply to zincpony it just depends on what tables and fields were created for him.

After I re-uploaded it I was able to do a clean uninstallation of the product. After that I uploaded the new product-timeslips1.2.xml and everything worked fine except for the $vbphrase function. For some reason some of them were giving me problems. I couldn't get the following to show up at all:

Code:
$vbphrase[timeslips]
$vbphrase[edit_timeslips]
$vbphrase[yes]
$vbphrase[no]
$vbphrase[timeslips_keep_current_timeslip]
$vbphrase[timeslips_keep_current_timeslip_define]
$vbphrase[timeslips_upload_timeslip_from_computer]

hotwheels 12-07-2006 07:58 PM
Quote:
Originally Posted by fkatzenb (Post 1134058)
50 thru 65 exist. 63-65 are arrays... a:3:{etc...}
Are they named? If you follow the line, are their title's and so forth in there?

zincpony 12-07-2006 08:17 PM
mine is just crapping on me, the only input field that shows up is the HorsePower field and the ability to upload a timeslip but nothing else, they vanished somewhere.

TurboLaserAWD 12-07-2006 08:31 PM
Okay I dunno how it happened but my phrases worked themselves out so now I'm all good. :)

zincpony 12-07-2006 08:34 PM
im still missing all my fields.

zincpony 12-07-2006 08:41 PM
how can i manually remove this from my database completely, cause no uninstall was provided.

TurboLaserAWD 12-07-2006 10:30 PM
Go into your database in phpMyAdmin, then go into the "profilefileds" table and click "Browse" at the top. Delete fields 50-65. Then go to the "userfields" table and do the same thing.

That's actually an incomplete way. I would recommend re-importing the original product-timeslips.xml file and then follow my directions here: https://vborg.vbsupport.ru/showpost....&postcount=434


All times are GMT. The time now is 12:19 AM.
Page 44 of 87 « First 344243 44 454654 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01371 seconds
  • Memory Usage 1,755KB
  • 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_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