vb.org Archive - Add-On Releases - Limited Guest Viewing -- Motivate Guests to Register

Page 37 of 41

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)

- - Add-On Releases - Limited Guest Viewing -- Motivate Guests to Register (https://vborg.vbsupport.ru/showthread.php?t=178720)

mariocaz

10-01-2009 01:48 AM

Thank you Ted,

Let me try it.

mariocaz

10-01-2009 01:55 AM

Help Ted !!!!!!!

Now I am receiving tons of this errors in my email:

Database error in vBulletin 3.7.6:

Quote:

Invalid SQL:

SELECT id,views
FROM vblgv AS lgv
WHERE lgv.ipaddress = '186.15.15.217';

MySQL Error : Table 'allreef_inicio.vblgv' doesn't exist
Error Number : 1146
Request Date : Wednesday, September 30th 2009 @ 10:53:50 PM
Error Date : Wednesday, September 30th 2009 @ 10:53:50 PM
Script : http://www.all-reefs.com/inicio/showthread.php?t=7433
Referrer : http://www.all-reefs.com/inicio/forumdisplay.php?f=20
IP Address : 186.15.15.217
Username : No Registrado
Classname : vB_Database
MySQL Version :

Help.

mariocaz

10-01-2009 02:02 AM

Mmmm I don´t know why the vblgv table doesn´t exist.

I ran the the xml files in the ACP.

I don´t know how to create a table, if you want give me tha SQL instructions to do it in the phpmyadmin or another xml file.

I think when I uninstalled the mod I deleted the table but when I reinstalled it the table had to be installed again.

Ted S

10-01-2009 02:34 AM

The table can be created with the SQL:

Code:

CREATE TABLE PREFIXlgv (

        id int(7) unsigned NOT NULL auto_increment,

        ipaddress VARCHAR(25) NOT NULL default '0.0.0.0',

       firstaccess INT UNSIGNED NOT NULL DEFAULT '0',

       views INT(4) NOT NULL DEFAULT '0',

       lastactivity INT UNSIGNED NOT NULL DEFAULT '0',

        PRIMARY KEY (id),

        KEY indexs (ipaddress,views,lastactivity)

      ) TYPE=MyISAM

Be sure to change or remove PREFIX.

mariocaz

10-01-2009 02:42 AM

if the table complete is vblgv, Is this one the correct instruction ?

Quote:

CREATE TABLE vblgv (
id int(7) unsigned NOT NULL auto_increment,
ipaddress VARCHAR(25) NOT NULL default '0.0.0.0',
firstaccess INT UNSIGNED NOT NULL DEFAULT '0',
views INT(4) NOT NULL DEFAULT '0',
lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY indexs (ipaddress,views,lastactivity)
) TYPE=MyISAM

or like this:

Quote:

CREATE TABLE lgv (
id int(7) unsigned NOT NULL auto_increment,
ipaddress VARCHAR(25) NOT NULL default '0.0.0.0',
firstaccess INT UNSIGNED NOT NULL DEFAULT '0',
views INT(4) NOT NULL DEFAULT '0',
lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY indexs (ipaddress,views,lastactivity)
) TYPE=MyISAM

Sorry if I am stupid, but I want to be sure before to run it.

mariocaz

10-01-2009 03:02 AM

Ted,

In this moment (I didn?t ran the SQL instruction yet, I am waiting your confirmation) I am receiving this errors:

Quote:

Database error in vBulletin 3.7.6:

Invalid SQL:

DELETE FROM vblgv
WHERE (lastactivity + ( * 86400)) < 1254369635;

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 '* 86400)) < 1254369635' at line 2
Error Number : 1064
Request Date : Thursday, October 1st 2009 @ 12:00:35 AM
Error Date : Thursday, October 1st 2009 @ 12:00:35 AM
Script : http://www.all-reefs.com/inicio/cron...and=1254369633
Referrer : http://www.all-reefs.com/inicio/onli...e&pp=20&page=1
IP Address : 189.142.218.197
Username : No Registrado
Classname : vB_Database
MySQL Version :

mariocaz

10-01-2009 03:26 AM

Ok I already ran the SQL instruction and I have now the table vblgv, but still receiving a lot of these errors by email:

Quote:

Database error in vBulletin 3.7.6:

Invalid SQL:

DELETE FROM vblgv
WHERE (lastactivity + ( * 86400)) < 1254370945;

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 '* 86400)) < 1254370945' at line 2
Error Number : 1064
Request Date : Thursday, October 1st 2009 @ 12:22:25 AM
Error Date : Thursday, October 1st 2009 @ 12:22:25 AM
Script : http://www.all-reefs.com/inicio/cron...and=1254370943
Referrer : http://www.all-reefs.com/inicio/show...?t=5752&page=6
IP Address : 189.217.98.64
Username : No Registrado
Classname : vB_Database
MySQL Version :

Ted S

10-01-2009 04:15 AM

That error is on the backend only but still needs to be fixed.

How often do have the scheduled task running? What is the value for the setting "Clear IP Activity Log"?

yahsuah

12-18-2009 10:15 PM

http://www.pdfonline.com/web2pdf/index.asp

Is it possible that I can use this script together with LGV plug-in?

I tried but it hasn't worked together.

How can I exclude this website: http://web2.pdfonline.com/pdfonline/pdfonline.js

HTML Code:

<!-- START: PDF Online Script -->

<script type="text/javascript">

        var authorId = "CED9DC99-40A8-4A21-9709-D89FD891A8F3";

        var pageOrientation = "0";

        var topMargin = "0.5";

        var bottomMargin = "0.5";

        var leftMargin = "0.5";

        var rightMargin = "0.5";

</script>

<script type="text/javascript" src="http://web2.pdfonline.com/pdfonline/pdfonline.js">

</script>

<!-- END: PDF Online Script -->

Ted S

12-19-2009 06:36 AM

This code would not impact javascript files.

All times are GMT. The time now is 03:17 AM.

Page 37 of 41

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01436 seconds Memory Usage 1,751KB 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 (1)bbcode_html_printable (5)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: