vb.org Archive

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)

tommyxv 03-21-2006 08:53 PM

Quote:

Originally Posted by tommyxv
Some FYI: If you deleted one of the profile fields for whatever reason, you won't be able to uninstall this product. It will give you a database error because the field is no longer there. You have to remove it from the uninstall code to have it uninstall correctly.

I want Fields 50 and 51 to be drop downs, so I have changed the XML.

Seems to work well.

For the people having un-install issues, you may need to follow this.

Quote:

Originally Posted by fkatzenb
Sorry, the flu sucks and is sapping my thoughts. When you are logged into VB and view details for each slip entry, the hopepage is your hopepage in every case.


Frank

Do you have the latest version becuase that was fixed.

EDIT: Also for anyone installing this, it's highly unlikey but make sure you don't already have profile field numbers 50 and up or you will have problems. If you don't want certain fields, it's best to remove them from the XML before you install it. This way you can remove it later down the line withour problems. EX: I decided not to use "Density Altitude" so i removed all traces of that field from the install and uninstall code. Also of you want certain field to be drop downs, you need to change "input" to "select" for that field in the XML.

tbroush 03-21-2006 08:57 PM

Quote:

For the people having un-install issues, you may need to follow this.
I try running the query for the uninstall code and I get errors also. I'm running mysql 4.0.12 or something like that.

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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("DROP TABLE " . TABLE_PREFIX . "customfile")'

tommyxv 03-21-2006 09:09 PM

Did you delete any of the fields that were created (50 to 65)? If so that is the only un-install error that I have come across. I have installed and uninstalled this over 20 times as I am customizing it, with out problem. If it's beyond that, you might need to wait for Death to chime in.

tbroush 03-21-2006 09:19 PM

Quote:

Did you delete any of the fields that were created (50 to 65)? If so that is the only un-install error that I have come across. I have installed and uninstalled this over 20 times as I am customizing it, with out problem. If it's beyond that, you might need to wait for Death to chime in.
This a fresh install for this site, never had this feature before, I checked the database and I only have 6 profile fields, none are within the numbers on this installation so I'm guessing is not installing correctly for some reaso I guess.

92GreenGT 03-21-2006 10:00 PM

So is the error I posted anything to worry about or should I just go on with the install? I have had Timeslip mod on my site before. Thanks

92GreenGT 03-21-2006 10:21 PM

Went ahead and installed it, when I click "Timeslips" on my navbar it takes me to a blank white page and when I click "Edit Vehicle Profile" in my User CP it takes you to a blank page. Is this related to the product error I got earlier? Any help is appreciated. Thanks

tommyxv 03-21-2006 10:35 PM

This is for boards that have never had this installed. You might want to check out the upgrade version here: https://vborg.vbsupport.ru/showthread.php?t=104471

tommyxv 03-21-2006 10:39 PM

Quote:

Originally Posted by scroush
This a fresh install for this site, never had this feature before, I checked the database and I only have 6 profile fields, none are within the numbers on this installation so I'm guessing is not installing correctly for some reaso I guess.

Not sure why your having issues. I am runing this on my test board (clean vb install) first and while I making my customizations, Installs without any problems. I am running Mysql 4.1.14 though.

92GreenGT 03-21-2006 11:03 PM

Anyone help me?

tbroush 03-21-2006 11:56 PM

Quote:

Anyone help me?
I ran into your same issue, after I deleted everything from my database. What I did to get it to worked was I went to the product manager and uninstalled and reinstalled the product and is finally showing up, now I got to find out if is going to let me add stuff to it.

92GreenGT 03-22-2006 12:08 AM

I had Timeslip database already installed ya know, I deleted all the templates and files that I knew of but it was still showing up in my Vbulletin options section. Maybe there are still some old files from versions before thats messing mine up? How do you know if you completely get rid of all the old stuff?

Sidewindr 03-22-2006 03:43 AM

Quote:

Originally Posted by 92GreenGT
When trying to install the product I get this error:

Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

                                INSERT INTO setting
                                (varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
                                VALUES
                                (
                                        'allowtimeslipupload',
                                        'timeslips',
                                        '1',
                                        '1',
                                        'boolean',
                                        'yesno',
                                        10,
                                        0,
                                        1,
                                        'timeslips'
        ),
        (
                                        'tdmaxwidth',
                                        'timeslips',
                                        '600',
                                        '600',
                                        'free',
                                        '',
                                        20,
                                        0,
                                        1,
                                        'timeslips'
        ),
        (
                                        'tdmaxheight',
                                        'timeslips',
                                        '600',
                                        '600',
                                        'free',
                                        '',
                                        30,
                                        0,
                                        1,
                                        'timeslips'
        ),
        (
                                        'tdmaxsize',
                                        'timeslips',
                                        '80000',
                                        '8000',
                                        'free',
                                        '',
                                        40,
                                        0,
                                        1,
                                        'timeslips'
        ),
        (
                                        'tdsliprequired',
                                        'timeslips',
                                        '10.00',
                                        '',
                                        'free',
                                        '',
                                        50,
                                        0,
                                        1,
                                        'timeslips'
        );

MySQL Error  : Duplicate entry 'allowtimeslipupload' for key 1
Error Number : 1062
Date        : Tuesday, March 21st 2006 @ 01:51:18 PM
Script      : http://www.fxxx.com/admincp/plugin.php
Referrer    : http://www.fxxx.com/admincp/plugin.php?do=productadd
IP Address  : xxxxxxxxxxx
Username    : xxxxxxxxxxx
Classname    : vb_database


Check allow overwrite I'd hazzard a guess.

tommyxv 03-22-2006 04:22 AM

Sidewindr, i am getting browers error on page in IE and FF.

Syntax error in this javascript,

Code:

<script language="javascript">
<!--

function validate(theform) {

        if ((theform.ctb_field55.value<=) && (theform.ctb_field55.value>0)) {
                if ((theform.upload.value=="") && (theform.timeslipdateline.value=="") && (theform.ctb_field57.value=="")) {
                        alert("An uploaded copy of or a link to your timeslip is required if your 1/4 mile ET is  or quicker.");
                        return false;
                } else if ((theform.upload.value=="") && (theform.timeslipdateline.value=="")) {
                        if ((theform.ctb_field57.value.search(/^http\:\/\/[a-zA-Z]...*\.[a-zA-Z]..\.[jJ][pP][gG]$/) == -1) && (theform.ctb_field57.value.search(/^http\:\/\/[a-zA-Z]...*\.[a-zA-Z]..\.[gG][iI][fF]$/) == -1)) {
                                alert("Incorrect Link Supplied for Timeslip Image.");
                                return false;
                        }
                }
        }
}
//-->
</script>

Missing a value?

EDIT: Here is what FF shows

fkatzenb 03-22-2006 10:25 AM

Quote:

Originally Posted by 92GreenGT
I had Timeslip database already installed ya know, I deleted all the templates and files that I knew of but it was still showing up in my Vbulletin options section. Maybe there are still some old files from versions before thats messing mine up? How do you know if you completely get rid of all the old stuff?

You still have the stuff in the SQL database. You have to manually clean these out and then attempt this again. Then there will be other steps you have to do. If you want me to do it, hit me up in a PM.


Frank

deathemperor 03-22-2006 04:41 PM

03/23/2006: Update: fix a JS error when submitting the new timeslip. (Thanks Sidewindr). Also the new product will attempt to remove your old vb3.0 options then add the new ones, this is for upgrading from timeslips for vb3.0 to vb3.5 . I didn't test that tho.

92GreenGT 03-22-2006 04:49 PM

Quote:

Originally Posted by fkatzenb
You still have the stuff in the SQL database. You have to manually clean these out and then attempt this again. Then there will be other steps you have to do. If you want me to do it, hit me up in a PM.


Frank

Can you point me in the right direction of cleaning the old files out of the SQL database? Thanks

92GreenGT 03-22-2006 04:51 PM

Quote:

Originally Posted by Sidewindr
Check allow overwrite I'd hazzard a guess.

Whats this mean? Sorry, newbie at all this.lol

tbroush 03-22-2006 05:52 PM

Quote:

Whats this mean? Sorry, newbie at all this.lol
When you go add the product in the forums cp it gives you an option to overwrite your current product.

92GreenGT 03-22-2006 06:04 PM

Quote:

Originally Posted by scroush
When you go add the product in the forums cp it gives you an option to overwrite your current product.

Ok, I done that. Click "Yes" on allow overwrite and it still didnt work. The old stuff in the SQL database is my problem, has to be. How can I clean that stuff out? Thanks for the PM and all. If I cant figure it out I might have to let you do it but your kind enough helping me out as it is, dont want you to have to take the time to fix my problems. BTW, you own a mustang?
-Edit- Looking at your name im guessing a supercharged roush?hehe

tbroush 03-22-2006 06:12 PM

Quote:

Ok, I done that. Click "Yes" on allow overwrite and it still didnt work. The old stuff in the SQL database is my problem, has to be. How can I clean that stuff out? Thanks for the PM and all. If I cant figure it out I might have to let you do it but your kind enough helping me out as it is, dont want you to have to take the time to fix my problems. BTW, you own a mustang?
-Edit- Looking at your name im guessing a supercharged roush?hehe
It used to be supercharged now is being fitted with a turbo. I don't have any problems helping you just let me know, is kind of hard to tell you exactly what to do in the database, you used have find everything that has to do with the timeslips database and delete it.

92GreenGT 03-22-2006 06:22 PM

Quote:

Originally Posted by scroush
It used to be supercharged now is being fitted with a turbo. I don't have any problems helping you just let me know, is kind of hard to tell you exactly what to do in the database, you used have find everything that has to do with the timeslips database and delete it.

I see

I have a 92GT as my name says with a MP T70, 38mm TiAL gate, 3" exhuast and currently running 7lbs on my stock 5 liter. I love turbos, I had a Vortech SC-Trim back in the day and made the swap a few months ago, its all a DIY kit and I love the power. Anyways back to forums, hehe.

I really wish I could learn about doing this stuff so I wouldnt have to get someone to do something like this for me all the time:(

tbroush 03-22-2006 08:13 PM

Quote:

I see

I have a 92GT as my name says with a MP T70, 38mm TiAL gate, 3" exhuast and currently running 7lbs on my stock 5 liter. I love turbos, I had a Vortech SC-Trim back in the day and made the swap a few months ago, its all a DIY kit and I love the power. Anyways back to forums, hehe.

I really wish I could learn about doing this stuff so I wouldnt have to get someone to do something like this for me all the time
Cool we order a SL T76 from turbonetics and it has being almost a month and still no turbo, we are probably going to cancel the order and go with a Precision or Innovative one, not sure yet.

Let me know if you need me to go into the databse for you.

Carlos

Sidewindr 03-23-2006 12:39 AM

Quote:

Originally Posted by tommyxv
Sidewindr, i am getting browers error on page in IE and FF.

Syntax error in this javascript,

Code:

        if ((theform.ctb_field55.value<=) && (theform.ctb_field55.value>0)) {
Missing a value?

EDIT: Here is what FF shows

The problem is in that line ... it should be ..

Code:

        if ((theform.ctb_field55.value<=$vboptions[tdsliprequired]) && (theform.ctb_field55.value>0)) {
Not sure why yours is missing the vboptions bit. Do you have tdsliprequired set in your vbulletin options ??

deathemperor 03-23-2006 01:49 AM

Quote:

Originally Posted by Sidewindr
The problem is in that line ... it should be ..

Code:

        if ((theform.ctb_field55.value<=$vboptions[tdsliprequired]) && (theform.ctb_field55.value>0)) {
Not sure why yours is missing the vboptions bit. Do you have tdsliprequired set in your vbulletin options ??

if he is missing tdsliprequired options. then that's the old timeslips, the version that doesn't allow users to upload picture.

tommyxv 03-23-2006 02:53 AM

Quote:

Originally Posted by Sidewindr
The problem is in that line ... it should be ..

Code:

        if ((theform.ctb_field55.value<=$vboptions[tdsliprequired]) && (theform.ctb_field55.value>0)) {
Not sure why yours is missing the vboptions bit. Do you have tdsliprequired set in your vbulletin options ??

I decided to can this hack, not becuase of these minor fixable issues but I rather re-code it to have it's own tables in the database and not use custom profile fields. The will also get ride of all file edits.

Thanks anyway.

ddolliver 03-24-2006 02:03 PM

OK, I'm dumb...where do I find the php files to modify...please keep it simple!

Thanks!

deathemperor 03-24-2006 02:18 PM

they are in your forum directory, if it's function_user.php then it's in forum/includes/

ddolliver 03-24-2006 02:51 PM

Thanks for the quick reply!

0ptima 03-26-2006 03:51 AM

Quote:

Originally Posted by tommyxv
I decided to can this hack, not becuase of these minor fixable issues but I rather re-code it to have it's own tables in the database and not use custom profile fields. The will also get ride of all file edits.

Thanks anyway.

Any plans on releasing it? By having its own tables, you could add multiple time slips!

CanuckDave 03-26-2006 02:49 PM

Just wanted to report that I followed the instructions documented in the txt file and the thread, and didn't run into a single problem, its installed and working perfectly, as far as I can tell so far.
thanks very much to everybody involved in working on this!!

bouncer18 03-27-2006 01:19 AM

deathemperor:

is there a way to clear out the DB.. you know start it over fresh again.. this possible ?

deathemperor 03-27-2006 01:21 AM

yes, I know. If you know what mysql, then open the old vb3.0 installer of timeslips database, then revert those database changes.

ddolliver 03-28-2006 04:06 AM

How do I give moderators the rights to add, delete and in general control the Timeslip DB?

deathemperor 03-28-2006 08:17 AM

That function is not available at the moment.

ddolliver 03-28-2006 11:42 AM

Soon maybe?:banana:

92GreenGT 03-29-2006 07:11 PM

Code:

Invalid SQL:
SELECT COUNT(*) AS users
                                    FROM user AS user, userfield AS userfield
                                   
                                      WHERE userfield.field55>0
                                    AND user.userid = userfield.userid;

MySQL Error  : Unknown column 'userfield.field55' in 'where clause'
Error Number : 1054
Date        : Wednesday, March 29th 2006 @ 01:10:19 PM
Script      : http://www.forums.com/timeslips.php?
Referrer    : http://www.forums.com/member.php?u=1140
IP Address  : XXXXXXXXXXXX
Username    : XXXXXXXXXXXX
Classname    : vb_database

Is the error I get when I click on the Timeslip link in the Navbar?

Sidewindr 03-30-2006 01:36 AM

Looks like the installer didn't creat field55 in the userfield table ..

Do you have remnents of an old timeslip database on your system??

Silver_2000_)! 03-30-2006 02:16 AM

Im getting this error when trying to upload the product

atal error: Call to a member function on a non-object in /home/site/public_html/forum/admincp/plugin.php(1232) : eval()'d code on line 5

Anyone know why ? I had the old Evil LS1 version already installed

Silver_2000_)! 03-30-2006 04:52 PM

anyone have any ideas ??

rcull 03-31-2006 02:26 AM

deathemperor

I have just made what looks like a successful instal!

For those that are running CMPS, you might like to suggest the user might like to add the full url on line 151:

<td class="vbmenu_control"><a href="http://www.yoursite.com/forum/timeslips.php?$session[sessionurl]">$vbphrase[timeslips]</a></td>


All times are GMT. The time now is 01:20 AM.

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.01968 seconds
  • Memory Usage 1,867KB
  • 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
  • (7)bbcode_code_printable
  • (19)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