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)

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


All times are GMT. The time now is 09:10 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.01936 seconds
  • Memory Usage 1,752KB
  • 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
  • (1)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