vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Add-On Releases - vBExperience (https://vborg.vbsupport.ru/showthread.php?t=171014)

abroad 02-20-2008 01:39 PM

Quote:

Originally Posted by Phalynx (Post 1447330)
No, it's only for 3.7 and higher


Did you run the step 4 after importing the products?


See "Impact on performance" in my description

yes but what do I have to do now????

abroad 02-20-2008 01:47 PM

Uninstalled and installed again. Same error:

Invalid SQL:
SELECT * FROM vb_xperience_stats WHERE userid=1 LIMIT 0,1;

MySQL Error : Table 'usr_web99_8.vb_xperience_stats' doesn't exist
Error Number : 1146

Yes, Prefix is vB_

Phalynx 02-20-2008 01:47 PM

Quote:

Originally Posted by abroad (Post 1447333)
yes but what do I have to do now????

I changed the installation code a bit, please re-download the ZIP, uninstall and install the main product again.

abroad 02-20-2008 02:02 PM

Now I get this error during the installation of the second product (small):

Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:
DELETE FROM vb_xPerience_Level;

MySQL Error : Table 'usr_web99_8.vb_xPerience_Level' doesn't exist
Error Number : 1146

Phalynx 02-20-2008 02:08 PM

Seems your *NIX (?) server is a little bit case sensitive regarding table names - I'm using Windows 2003 Server and there are no problems with that.

I fixed all XML, the XLS and updated the ZIP.

abroad 02-20-2008 02:11 PM

I think my hoster has an Apache Server. Did you fix everything after my last posting so I can try it again?

vgjhav 02-20-2008 02:23 PM

I really like the idea.

What would make this awesome. Is a way for member to redeem their points. Say via paypal.

It could automatically deduct the points and send an email to the super admin giving details of who needs to be paid and how much.

Can be extremely simple.

Let me know if it interests you or others. You can do it, or let me know and i can create something that will integrate it easy.

Phalynx 02-20-2008 02:28 PM

Quote:

Originally Posted by abroad (Post 1447358)
Did you fix everything after my last posting so I can try it again?

Yes, it should be fixed. Waiting for your confirmation that it's now running.

Quote:

Originally Posted by vgjhav (Post 1447367)
I really like the idea.

What would make this awesome. Is a way for member to redeem their points. Say via paypal.

It could automatically deduct the points and send an email to the super admin giving details of who needs to be paid and how much.

Nice idea. Also an integration to vBCredits and similar would be possible.

abroad 02-20-2008 02:34 PM

Now it should work...no error messages anymore...will test it a bit :) Thanks a lot

Bilderback 02-20-2008 02:56 PM

EDIT: new update fixed error below- thanks-installed

Error in SQL when updating Cron
Code:

Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:
SELECT
        u.username,
        u.userid,
        u.joindate,
        u.reputation,
        u.usergroupid,
        u.ipoints,
        u.posts
        FROM vb_user as u
        WHERE xperience_done=0 AND userid NOT IN();

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 ')' at line 10
Error Number  : 1064
Script        : http://*******.***/forum/admincp/cronadmin.php?do=runcron&cronid=25
Classname    : vb_database
MySQL Version : 4.0.27-standard-log



All times are GMT. The time now is 06:04 PM.

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.02764 seconds
  • Memory Usage 1,740KB
  • 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_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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