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)
-   -   Mini Mods - Inactive Users Email Reminders For 3.7.x (https://vborg.vbsupport.ru/showthread.php?t=188383)

wingrider 08-17-2008 05:41 PM

There is a syntax error in your code. It brought my system down completely... Database Error. I can't even access the AdminCP. Others BEWARE before installing this upgrade.

Gene Steinberg 08-17-2008 05:50 PM

Maybe, but I haven't had any trouble at all.

C Braithwaite 08-17-2008 05:55 PM

Quote:

Originally Posted by genesteinberg (Post 1600844)
Just some suggestions: How about having this product email you a daily reminder report in the same fashion as the other product that performs this function?

Also, when you get a message that a member's email address is no longer valid, how about an option to automatically disable that person's membership? It beats manual, particularly when you've got several dozen or more to go through?

Peace,
Gene

I'm about to upload an update that does just that.. watch this space..
Quote:

Originally Posted by SwollenCranium (Post 1600814)
Same here.
'Disable hooks' was my only way to gain access.
Uninstalled.

Quote:

Originally Posted by abrecher (Post 1600799)
This mod is crashing my database. I had to uninstall.

Quote:

Originally Posted by wingrider (Post 1600885)
There is a syntax error in your code. It brought my system down completely... Database Error. I can't even access the AdminCP. Others BEWARE before installing this upgrade.

Sorry this has messed up for you guys - is there any chance you still have a copy of the email with the error? problem is, it works fine on mine so its hard to test...

Quote:

Originally Posted by Endurer (Post 1600845)
I have the 3.6 version installed, should I uninstall that one and install this one?

no.

wingrider 08-17-2008 06:14 PM

C Braithwaite, Apparently the error is coming from the content of the outgoing message, which I changed in the CP from your default message. Looking below, I see a '\' symbol in the word 'haven\'t', but it does not display that way in the MySQL database table.

Can you tell me how to remove the plugin when I don't have AdminCP access? I have FTP and PHPMyAdmin, so maybe you can tell me what file to remove to make it stop sending data to the mailqueue. Any help would be appreciated. Sorry to turn your thread into a support center. I have a ticket open with vBulletin support.

Don
--------------------------------------------------------------------------------------------

<!--
Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT INTO mailqueue (dateline,toemail,fromemail,subject,message,header ) VALUES ('1219000005','lclowry@execulink.com','rvpicsmail@ sbcglobal.net','We Miss You!!','&lt;p&gt;Dear Travelin'on&lt;/p&gt;

&lt;p&gt;We haven\'t seen you check in with RVPics for a while. Your participation is very important to us. Please stop by when you have a chance.&lt;/p&gt;

&lt;p&gt;Regards&lt;br/&gt;
The Team
&lt;a href=&quot;http://www.rvpics.com/forums/index2.php&quot;&gt;RV Pics&lt;/a&gt;&lt;/p&gt;','MIME-Version: 1.0
Content-type: text/html; charset=iso-8859-1
To: Travelin'on &lt;lclowry@execulink.com&gt;
From: RV Pics Reminder Service &lt;rvpicsmail@sbcglobal.net&gt;
');

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 'on&lt;/p&gt;

&lt;p&gt;We haven\'t seen you check in with RVPics for a while. Your partic' at line 1
Error Number : 1064
Request Date : Sunday, August 17th 2008 @ 01:06:45 PM
Error Date : Sunday, August 17th 2008 @ 01:06:45 PM
Script : http://www.rvpics.com/forums/index.php
Referrer :
IP Address : 75.6.163.23
Username :
Classname : vB_Database
MySQL Version :
-->

C Braithwaite 08-17-2008 06:19 PM

any feedback is great - sorry abut this... go into phpmyadmin and find "datastore" delete the entry "pluginlist" ad then you can disable the product from there.

the \ are supposed to stop the errors.. i will double check but i think i've fixed it in this version..

wingrider 08-17-2008 06:32 PM

OK, I got as far as deleting 'pluginlist'. How do I disable the product? I still can't open the AdminCP... I get: Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/includes/init.php on line 271 on the html page.

Ross L 08-17-2008 07:05 PM

Quote:

Originally Posted by wingrider (Post 1600918)
OK, I got as far as deleting 'pluginlist'. How do I disable the product? I still can't open the AdminCP... I get: Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/includes/init.php on line 271 on the html page.

The easiest way is to go to your config.php and just after the

PHP Code:

<?php

add this

PHP Code:

define('DISABLE_HOOKS'true); 

This disables all plugins on the site.

Then login to your ADMINCP and uninstall the product. Then just delete that line from config file and reupload it.

Gene Steinberg 08-17-2008 07:31 PM

Quote:

Originally Posted by C Braithwaite (Post 1600910)
any feedback is great - sorry abut this... go into phpmyadmin and find "datastore" delete the entry "pluginlist" ad then you can disable the product from there.


the \ are supposed to stop the errors.. i will double check but i think i've fixed it in this version..

I can't find such an entry in datastore. Where is it supposed to be. The forum is locked up tight after installing your new version. This was a bad move.

:(

wingrider 08-17-2008 07:31 PM

Back up and working (minus this plugin, unfortunately). Thanks to all for the help.

Don

Gene Steinberg 08-17-2008 07:35 PM

Quote:

Originally Posted by wingrider (Post 1600963)
Back up and working (minus this plugin, unfortunately). Thanks to all for the help.

Don

Back up here too.

But the 1.2.2 version is toxic and I will not use this product until I know it works.

One more thing: Just listing the names of people whose emails are incorrect isn't sufficient for my purposes. There ought to be a way to move those members into a new category until that's resolved.

But first fix the database problem.

Peace,
Gene


All times are GMT. The time now is 02:54 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.01430 seconds
  • Memory Usage 1,753KB
  • 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
  • (2)bbcode_php_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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