vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Profile Enhancements - e-steki Karma version 2.2 (https://vborg.vbsupport.ru/showthread.php?t=154264)

lasto 08-05-2007 03:30 AM

Warning: implode() [function.implode]: Bad arguments. in /karma.php on line 125

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /karma.php on line 129

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /karma.php on line 342

and thats putting a 0 in the main karma setting

Hate to say it but after messing it simply dont work on 3.6.8

also i loaded the new karma.php that u had on the previous page and here is the error i get now

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /karma.php on line 342
Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM userrating WHERE active=1 AND userid NOT IN () AND raterid NOT IN () ORDER BY `dateline` DESC;

MySQL Error : 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 ') AND raterid NOT IN () ORDER BY `dateline` DESC' at line 1
Error Number : 1064
Date : Sunday, August 5th 2007 @ 12:32:08 AM

finally look what happens if i try to uninstall the product from the admincp

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE user DROP karmatotal;

MySQL Error : Can't DROP 'karmatotal'; check that column/key exists
Error Number : 1091
Date : Sunday, August 5th 2007 @ 12:39:04 AM

Lea Verou 08-05-2007 03:58 AM

Damn.
I'll try to fix this shortly.
For the time, disable the product.

Lea Verou 08-05-2007 05:03 AM

lasto, do you have any banned users? (not karma-banned, generally banned)

Lea Verou 08-05-2007 05:05 AM

Also, try putting a 0,0 instead of a 0 in that setting and tell me what happened

TheBlackPoet 08-05-2007 05:50 AM

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE usergroup ADD userratingday SMALLINT(4) NOT NULL DEFAULT '0', ADD userratingperm INT(10) NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'userratingday'
Error Number : 1060
Date : Sunday, August 5th 2007 @ 01:47:30 AM
Script : http://www.theblackpoet.com/xxxxxx/a...=productimport
Referrer : http://www.theblackpoet.com/xxxxx/ad...?do=productadd
IP Address : xxxxxxx
Username : xxxxxx
Classname : vB_Database


this is my error.. i go to import... and get this.....

ged 08-05-2007 06:18 AM

And I didn't have any of my templates changed.

Lea Verou 08-05-2007 06:19 AM

Quote:

Originally Posted by TheBlackPoet (Post 1310155)
Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE usergroup ADD userratingday SMALLINT(4) NOT NULL DEFAULT '0', ADD userratingperm INT(10) NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'userratingday'
Error Number : 1060
Date : Sunday, August 5th 2007 @ 01:47:30 AM
Script : http://www.theblackpoet.com/xxxxxx/a...=productimport
Referrer : http://www.theblackpoet.com/xxxxx/ad...?do=productadd
IP Address : xxxxxxx
Username : xxxxxx
Classname : vB_Database


this is my error.. i go to import... and get this.....

Which hacks that involve DB changes do you have? It's quite weird to have this.
Anyway, that column is not needed in v2, its from the install code of v1. It then gets removed with the install code of v2, so perhaps I should remove it completely.

Lea Verou 08-05-2007 06:20 AM

Quote:

Originally Posted by ged (Post 1310164)
And I didn't have any of my templates changed.

Huh? What do you mean?

PS: Nice avatar

TheBlackPoet 08-05-2007 06:24 AM

Quote:

Originally Posted by Michelle (Post 1310166)
Which hacks that involve DB changes do you have? It's quite weird to have this.
Anyway, that column is not needed in v2, its from the install code of v1. It then gets removed with the install code of v2, so perhaps I should remove it completely.

i was jacking around with that commune hack and broke my dbase/site.... im reinstalling all my hacks now... after having to uninstall them all one by one...

i havent really been having any dbase issues since i took all my hacks off and ran tools.php...

i dont know why this one would give me any trouble

Lea Verou 08-05-2007 06:27 AM

Quote:

Originally Posted by TheBlackPoet (Post 1310168)
i was jacking around with that commune hack and broke my dbase/site.... im reinstalling all my hacks now... after having to uninstall them all one by one...

i havent really been having any dbase issues since i took all my hacks off and ran tools.php...

i dont know why this one would give me any trouble

Since you are a coder, you can edit the product xml and remove any queries about that column (userratingday) in the install/uninstall code, its not needed at all, it gets added and then removed during install, in order to have consistency with users having v1 (v1 needed that column).
It's weird though that you have such a column in your db..
If you can't do the above, tell me to upload a product xml without it.


All times are GMT. The time now is 12:19 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.01695 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
  • (4)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
  • (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