vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB Timeslip Database -for Automotive websites (https://vborg.vbsupport.ru/showthread.php?t=60945)

rcull 11-12-2006 03:19 PM

Mmmm...

I was running vb3.5.4 with timeslip v1.1.4, I have upgraded to vb3.6.2.

So in order to get my timeslips back up and running, I shouldn't upgrade to timelslip 2.1?

I should just go back and check all the "phrases to add" and continue with the timeslip v1.1.4?

hotwheels 11-12-2006 04:08 PM

v2.1 is for 3.0............

You will just need to use the one in the link from right above your last post.......

rcull 11-15-2006 02:11 PM

Sorry, the first instal went so well, this fix ain't...

When I click on a users name in the timeslip list, I get:

Invalid SQL:

SELECT profilefieldid, required, title, type, data, def, height
FROM vb3_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 : Wednesday, November 15th 2006 @ 04:05:15 PM
Script : http://www.teambuick.com/forums/member.php?u=3645
Referrer : http://www.teambuick.com/forums/timeslips.php?
IP Address : 24.66.129.166
Username : rcull
Classname : vb_database


It seems for whatever reason, I now need a profile field "title".
I have clicked on add a field, and find:

1 If field type is "enum" or "set", please enter the values using this format: 'a','b','c'...
If you ever need to put a backslash ("\") or a single quote ("'") amongst those values, precede it with a backslash (for example '\\xyz' or 'a\'b').

2 For default values, please enter just a single value, without backslash escaping or quotes, using this format: a



I have never done this before?!? or.... maybe I am just lost trying to fix this!

ALSO:
The descriptions are missing over all textboxes?

hotwheels 11-15-2006 07:38 PM

Rcull, you will need to follow these new instruction's to make it work correctly. https://vborg.vbsupport.ru/showpost....&postcount=354

What that error is telling you, is that you don't have the word "title" in the profilefield. You may need to make sure that your change's go with your mysql. My profilefield is named vb3profilefield, your's might be profilefield, without the vb3 in the front, so you would have to make the change's to the query as such.
Let me know if that make's sense man, i will stop by once in a while to see how thing's are going with the query run....

rcull 11-17-2006 03:21 PM

Hotwheels,

Thanks! I really enjoyed adding the title and description to the database. I learned a lot (twice nothing is still nothing...:)).

I still am experienceing a problem with fields not showing up. They now have aa and a over each textbox. Have I lost something else in my database?

http://www.teambuick.com/forums/prof...o=edittimeslip

I looks like it has something to do with the install TDinstaller.php which didn't run. It looks like I now have to add some data to the tables?

Thanks

hotwheels 11-17-2006 06:51 PM

Try going into your vbulletin admincp, and rerunning the .xml.......and click overwrite. Let me know what happens.
If you made the file edit's and then did the queries, (which it sounds like you did). You will need to run the .xml as the last step, this way it will run the rest of the queries that are in deathemperor's file.....

rcull 11-17-2006 11:02 PM

That doesn't seem to have solved the problem, and it sounded like such a good thing to do! What should I try next?
The aa seems to be coming from the Default2 in the title table
The a seems to be coming from the Default2 in the description table

It would appear that my tables need more development. I know this will work, I just wish I wasn't having so much difficulty.

Thanks

hotwheels 11-19-2006 02:15 PM

Okay rcull, i registered on your site today and had a look at your timeslip's......

First question, and without seeing your database and mysql, i won't know, but did you do all of the updated file need's?

PHP Code:

###### In image.php find:

if ($_REQUEST['type'] == 'profile'// do not modify this $_REQUEST


###### REPLACE IT WITH:

if ($_REQUEST['type'] == 'profile' or $_REQUEST['type'] == 'timeslip'// do not modify this $_REQUEST


###### FIND:

    
else
    {
        
$table 'customavatar';
    }

###### ABOVE THIS ADD:

    
else if ($_REQUEST['type'] == 'timeslip')
    {
        
$data 'timeslippicdata';
        
$table 'customfile';
    } 

etc............?

and etc......
PHP Code:

###### In member.php find:
// *********************
// CUSTOM PROFILE FIELDS
// CUSTOM PROFILE FIELDS
$profilefields $db->query_read_slave("
    SELECT profilefieldid, required, type, data, def, height
    FROM " 
TABLE_PREFIX "profilefield
    WHERE form = 0 " 
iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), "
        AND hidden = 0"
) . "
    ORDER BY displayorder
"
);



###### Replace it with:

// *********************
// CUSTOM PROFILE FIELDS
$profilefields $db->query_read_slave("
    SELECT profilefieldid, required, title, type, data, def, height
    FROM " 
TABLE_PREFIX "profilefield
    WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND form = 0 " 
iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), "
        AND hidden = 0"
) . "
    ORDER BY displayorder
"
); 


hotwheels 11-19-2006 02:51 PM

K, I tried to help make this a product.......

I need someone with a pretty much a new set up to give this a whirl.....and then let me know what happen's.

I just don't have a way to test at this point since all i have is an online site, i don't have a test site.

Now, If you test this you will need to do all of the file edit's as per my original instructions, accept i added the query's to this, so you hopefully won't need to run the queries seperately......I believe what is happening is that i didn't make a couple change's in death's original .xml file, and when you add the queries, my queries are being overwritten.....Hopefully with the change's i made, you should be able to upload the product, edit your image.php file and it's good to go.....

If you already have this installed but are having issue's with the title's being posted, just upload this .xml and click overwrite......let me know what happens.....

Please remember, i don't claim to be a coder, i am just trying to help make a great product, work again......

hotwheels

rcull 11-19-2006 04:39 PM

Hotwheels,

I checked the file edits, then I imported your new .xml and am still stalled.

I do have a test site that is still running 3.5.4 and I just installed timeslips 1.1.4 and it seems to be running. I could try the upgrade and see what happens, but I would be happy to send you the log in info. If you would like to contact me here, I will send the info to you.

I know your trying hard to help.

Thanks


All times are GMT. The time now is 08:08 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.01809 seconds
  • Memory Usage 1,760KB
  • 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_php_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