vb.org Archive
Page 11 of 22 « First 910 11 121321 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)

RoyMan 12-05-2006 01:32 PM
so from what im getting from the recent posts the new 1.2 version is for new installs of version 3.6 and does not work on upgrades from 3.5?

i guess im a bit confused sorry :(

deathemperor 12-05-2006 01:34 PM
Although tested in my localhost for new installation and upgrade

I beleive it means it does work on upgrades *only* from vb3.5

zincpony 12-06-2006 01:31 PM
alrite its installed and i tried to access it and i get this


Quote:
zincpony, you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
and when i try to uninstall it i get a data base error page with

Database error in vBulletin 3.6.4:
Code:
Invalid SQL:
DROP TABLE customfile;

MySQL Error  : Unknown table 'customfile'
Error Number : 1051
Date        : Wednesday, December 6th 2006 @ 07:48:40 AM
Script      : http://boostedmustangs.com/vbtester/admincp/plugin.php?do=productkill
Referrer    : http://boostedmustangs.com/vbtester/admincp/plugin.php?do=productdelete&productid=timeslips&s=
IP Address  : 68.80.158.100
Username    : zincpony
Classname    : vB_Database

deathemperor 12-06-2006 01:41 PM
Open the Timeslips options and edit its options.

zincpony 12-06-2006 02:16 PM
Quote:
Originally Posted by deathemperor (Post 1133195)
Open the Timeslips options and edit its options.
the only options i get are the time slip image length and width and E/T image requirements

deathemperor 12-06-2006 02:17 PM
edit yourself as a user, there is a option to let you use the timeslips or not.

zincpony 12-06-2006 02:45 PM
i know im being a pain but i dont see anything

ive looked in user options alone, and user groups everything.

zincpony 12-06-2006 02:55 PM
ok i found it changed it so i can edit own profile and

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE user SET tdban=1 WHERE userid=1;

MySQL Error  : Unknown column 'tdban' in 'field list'
Error Number : 1054
Date        : Wednesday, December 6th 2006 @ 08:54:41 AM
Script      : http://boostedmustangs.com/vbtester/admincp/user.php?do=update
Referrer    : http://boostedmustangs.com/vbtester/admincp/user.php?do=edit&u=1
IP Address  : 68.80.158.100
Username    : zincpony
Classname    : vB_Database
comes up it wont let me save it

zincpony 12-06-2006 04:11 PM
How can i manually uninstall it and try it once more

zincpony 12-07-2006 05:38 AM
Mine Just Refuses to work,

http://www.boostedmustangforums.com

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT *
                          FROM user AS user       
                          LEFT JOIN customfile AS customfile ON (customfile.userid = user.userid)
                          LEFT JOIN userfield AS userfield ON (userfield.userid = user.userid)
                          WHERE user.userid = userfield.userid
                          AND userfield.field55>0 
                          ORDER BY userfield.field55 ASC
                          LIMIT 0,25;

MySQL Error  : Table 'vbulletin.customfile' doesn't exist
Error Number : 1146
Date        : Wednesday, December 6th 2006 @ 11:37:44 PM
Script      : http://boostedmustangforums.com/timeslips.php?
Referrer    : http://boostedmustangforums.com/forumdisplay.php?f=10
IP Address  : 68.80.158.100
Username    : ZincPony
Classname    : vB_Database

Sidewindr 12-07-2006 05:48 AM
I have modified the xml slightly to do some checking for existing tables etc. This worked for me doing an "UPGRADE" from the old 3.5 version and all the profilefield tables are referenced correctly without having to create bogus profile field entries as in the other workarounds. I have also Australian ised it with HP changed to kW and Altitude etc to Date.

All I did was on my existing installation where the titles were missing because of the change to userprofile field layout etc is just overwrite my existing install with the 1.2.1 version attached here. i am running vBulletin 3.6.4 also.

zincpony 12-07-2006 05:52 AM
this thing just does not like me. :cry: :cry:

Sidewindr 12-07-2006 06:09 AM
Quote:
Originally Posted by zincpony (Post 1133672)
this thing just does not like me. :cry: :cry:
What's the problem ??

zincpony 12-07-2006 10:32 AM
look up two posts

the first attachment, the vb option attachment, show the only option i see with this add on, then the othen is the error i get when i try to change that option to yes, the vb error attachment comes up.

and i get another database fail when i try to uninstall it.


another thing my navbar template doesnt have

PHP Code:
<td class="vbmenu_control"><a href="memberlist.php?$session[sessionurl]">$vbphrase[members_list]</a></td 
it has a _q on the sessionurl
Code:
<td class="vbmenu_control"><a href="memberlist.php?$session[sessionurl_q]">$vbphrase[members_list]</a></td>

hotwheels 12-07-2006 12:29 PM
That error means it didn't write into your user field for some reason.......the alter table in the .xml need's to tell it to do so.....

hotwheels 12-07-2006 12:36 PM
Quote:
Originally Posted by sidewindr
without having to create bogus profile field entries as in the other workarounds.
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"......

zincpony 12-07-2006 01:31 PM
ok i got the time slips part working soo far, but now when click on a users logg in name it wont take me to their profile. just a broken page.


Code:
Database error in vBulletin 3.6.4:

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
Date        : Thursday, December 7th 2006 @ 10:31:18 AM
Script      : http://localhost/folder/member.php?u=1
Referrer    : http://localhost/folder/timeslips.php?
IP Address  : 127.0.0.1
Username    : ZincPony
Classname    : vB_Database
Code:
Script      : http://localhost/folder/member.php?u=1
Referrer    : http://localhost/folder/index.php
Code:
Script      : http://localhost/folder/member.php?u=1
Referrer    : http://localhost/folder/forumdisplay.php?f=2

the profile doesnt work from all referrers

hotwheels 12-07-2006 02:14 PM
Quote:
Originally Posted by zincpony (Post 1133847)
ok i got the time slips part working soo far, but now when click on a users logg in name it wont take me to their profile. just a broken page.


Code:
Database error in vBulletin 3.6.4:

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
Date        : Thursday, December 7th 2006 @ 10:31:18 AM
Script      : http://localhost/folder/member.php?u=1
Referrer    : http://localhost/folder/timeslips.php?
IP Address  : 127.0.0.1
Username    : ZincPony
Classname    : vB_Database
Code:
Script      : http://localhost/folder/member.php?u=1
Referrer    : http://localhost/folder/index.php
Code:
Script      : http://localhost/folder/member.php?u=1
Referrer    : http://localhost/folder/forumdisplay.php?f=2

the profile doesnt work from all referrers
The above error,
Quote:
Unknown column 'title' in 'field list'
is do to "title" not being in the profile field in your myphpadmin........If i was you at this point, i would wait and see if there is a better way to fix that, then my bogus query write into the profilefield......

hotwheels 12-07-2006 02:20 PM
zincpony, i registered on your site, let's get this badboy workin for ya......

zincpony 12-07-2006 02:23 PM
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

hotwheels 12-07-2006 02:27 PM
fkatzenb, yours looks fine bro..........seem's like everything is working right?

hotwheels 12-07-2006 02:33 PM
nevermind fkatzenb, yours isn't fine..........I noticed you don't have any of the lettering for your timeslips submit info......

fkatzenb 12-07-2006 03:31 PM
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

hotwheels 12-07-2006 03:38 PM
not a problem man, right now i am working with zincpony.........once i am done there, i will try to help ya out.....

TurboLaserAWD 12-07-2006 05:23 PM
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.

hotwheels 12-07-2006 05:26 PM
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.

hotwheels 12-07-2006 05:29 PM
Quote:
Originally Posted by TurboLaserAWD (Post 1133969)
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.
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.

TurboLaserAWD 12-07-2006 05:49 PM
Quote:
Originally Posted by hotwheels (Post 1133978)
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.

hotwheels 12-07-2006 06:08 PM
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...

hotwheels 12-07-2006 06:20 PM
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.

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 03:42 AM.
Page 11 of 22 « First 910 11 121321 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.01960 seconds
  • Memory Usage 1,874KB
  • 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
  • (13)bbcode_code_printable
  • (1)bbcode_php_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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