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)
-   -   Trader Ratings v1.2.0 (https://vborg.vbsupport.ru/showthread.php?t=65730)

Spinball 08-11-2004 12:00 PM

Jason,
hi mate - glad to see this hack is getting the popularity it deserves!
I have a problem with my installation.
Please see:
http://www.avforums.com/forums/trade...gs.php?u=12711
I.e.. null dates.
I had the first version of this hack for vB3 installed and upgraded vB to 3.0.3.
So I had to upgrade/reinstall the trader rating hack.
It did crash out (see my posting on the previous page).
Do you know where I went wrong and how to fix it?
Thanks.

lifesourcerec 08-11-2004 12:54 PM

Quote:

Originally Posted by oldfan
GREAT Add-on !!
I love to see a top 10/master feedback page.
I'm willing to throw some cash your way for it and I'm sure many others would too :)

I'm willing to pitch in.

lifesourcerec 08-11-2004 12:55 PM

Quote:

Originally Posted by Spinball
Jason,
hi mate - glad to see this hack is getting the popularity it deserves!
I have a problem with my installation.
Please see:
http://www.avforums.com/forums/trade...gs.php?u=12711
I.e.. null dates.
I had the first version of this hack for vB3 installed and upgraded vB to 3.0.3.
So I had to upgrade/reinstall the trader rating hack.
It did crash out (see my posting on the previous page).
Do you know where I went wrong and how to fix it?
Thanks.

When I upgraded to v3.0.3 from v3.0.1, I didn't have to do anything.

oldfan 08-11-2004 01:56 PM

Quote:

Originally Posted by lifesourcerec
I'm willing to pitch in.

See there two :)
eoc_Jason you got paypal?

eoc_Jason 08-11-2004 03:16 PM

Yes, one of the changes in this most recent version was the switch from a date field type to the int field type. The dates had to be regenerated in a new column, and the old column dropped, and indexes updated.

Open up the upgrade_traderratings.php file and look at the very very bottom. The script died at the part where it says:

PHP Code:

$DB_site->query("ALTER TABLE ".TABLE_PREFIX."user_rate_trade DROP INDEX rateduser_2"); 

The easiest thing to do would be to run the four SQL commands after it (assuming you do not have the rateduser_3 index) manually. Like in PHPMyAdmin, or I think you can run SQL from the vB control panel (I've never tried it that way though).

That's the reason all your dates are messed up, it's still trying to read the old date column and process it in the new format. If you still have people using the trader ratings script though, the dates will be missing for any new info that is submitted between the time you tried to update and now. If you have some PHP/MySQL skills then you might want to re-do just "Step 3" in the upgrade, but you will have to drop the datetmp column, and also might want to remove the drop's for the indexes which don't exist... ;)

oldfan - Check the first post, there is a paypal donation link. ;)

Quote:

Originally Posted by Spinball
Jason,
hi mate - glad to see this hack is getting the popularity it deserves!
I have a problem with my installation.
Please see:
http://www.avforums.com/forums/trade...gs.php?u=12711
I.e.. null dates.
I had the first version of this hack for vB3 installed and upgraded vB to 3.0.3.
So I had to upgrade/reinstall the trader rating hack.
It did crash out (see my posting on the previous page).
Do you know where I went wrong and how to fix it?
Thanks.


oldfan 08-11-2004 04:08 PM

Quote:

oldfan - Check the first post, there is a paypal donation link
Go have a beer on me now :)
Lets hope ALOT more people will help to inspire you too :)

oldfan 08-12-2004 01:44 PM

Anyone else going to pitchin?

Martaigne 08-12-2004 04:56 PM

Installed, works great on the first try!

Spinball 08-14-2004 06:46 AM

Thanks for your help, Jason. Have a drink on me. Paypal clicked.

eoc_Jason 08-14-2004 04:29 PM

Glad you got it updated... ;)


All times are GMT. The time now is 01:44 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.01378 seconds
  • Memory Usage 1,746KB
  • 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
  • (1)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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