vb.org Archive - Miscellaneous Hacks - Subscription Notifications -- Drive paid subscriptions & renewals

Page 14 of 18

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Miscellaneous Hacks - Subscription Notifications -- Drive paid subscriptions & renewals (https://vborg.vbsupport.ru/showthread.php?t=179864)

Puntoboy

12-23-2008 08:11 PM

I enabled this mod and suddenly database errors occured.

Ted S

12-23-2008 09:21 PM

Quote:

Originally Posted by Puntoboy (Post 1692330)

I enabled this mod and suddenly database errors occured.

Then disable it and post the actual error here so I can diagnose your forum's issue.

Lovinmysailor

12-23-2008 10:41 PM

Works great!!!!

Is there a way to make it so you can pick which subscription shows up?

Ted S

12-23-2008 11:45 PM

Quote:

Originally Posted by Lovinmysailor (Post 1692422)

Is there a way to make it so you can pick which subscription shows up?

What do you mean?

Puntoboy

12-24-2008 08:21 AM

Quote:

Originally Posted by Ted S (Post 1692372)

Then disable it and post the actual error here so I can diagnose your forum's issue.

I did that immediately.

Was unable to post the error at the time, but here it is.

Code:

Database error in vBulletin 3.7.3:



Invalid SQL:



                                                SELECT s.subscriptionid,s.userid,s.expirydate,u.username

                                                FROM vb3_subscriptionlog as s

                                                LEFT JOIN user as u ON s.userid = u.userid 

                                                ORDER BY subscriptionid DESC

                                                LIMIT 5;



MySQL Error   : Table 'puntosp_dbvb3forum.user' doesn't exist

Error Number  : 1146

Request Date  : Tuesday, December 23rd 2008 @ 10:15:21 PM

Error Date    : Tuesday, December 23rd 2008 @ 10:15:21 PM

Script        : http://www.puntosports.co.uk/forums/index.php?

Referrer      : 

IP Address    : 92.19.88.66

Username      : Nod

Classname     : vB_Database

MySQL Version :

Ted S

12-24-2008 04:39 PM

Quote:

Originally Posted by Puntoboy (Post 1692694)

I did that immediately.

Was unable to post the error at the time, but here it is.

Thanks! The issue was with table prefixes and has been resolved. Please install the new plugin file.

Ted S

12-24-2008 04:41 PM

An update version of this addon has been released to address a small bug in querying data when database table prefixes are activated.

Users not experiencing issues or who are not using table prefixes do not need to upgrade.

To upgrade simply install the new plugin file allowing overrides.

Puntoboy

12-25-2008 09:45 PM

Nice one. I'll give it a go now. Thank you.

snoopy5

01-12-2009 06:57 AM

Does it work with vb3.8?

Mum	01-12-2009 05:34 PM

i'm using it on 3.8 :)

All times are GMT. The time now is 07:59 AM.

Page 14 of 18

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02817 seconds Memory Usage 1,739KB 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 (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
Messages: