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

Page 32 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

04-19-2009 03:15 PM

Arrggg so sorry if I am stupid, Maybe something easy is that I can give you access to my forum to fix all this quickly, just tell me ok.

Or tell me exactly waht I have to do and I will do it, but I don?t know SQL instructions :( , so you have to give me the exactly SQL instructions to do this.

Ted S

04-19-2009 11:54 PM

Quote:

Originally Posted by mariocaz (Post 1794464)

Before I can help with your SQL queries I need to know if any tables with the name lgv exit in your database.

Ted S

04-20-2009 12:06 AM

Quote:

Originally Posted by zorton (Post 1794444)

Great plugin!

Just one question. How can I change the box color that surrounds the text?

I would like to use a different color (like the Sitepoint Sponsors box @ forum index) but don't know how to do it.

Thanks

The stop message is run through a template which you can modify. Just search your styles and change as desired.

mariocaz

04-20-2009 02:56 AM

Hi Ted,

No I don´t have any table with the name lgv in my DB.

So that is the problem, the mod didn´t install(create) the table in my DB, right ?

Ted S

04-20-2009 03:07 AM

That's correct. The installer was unable to create the table.

If you comment out the line $db->reporterror = 0; by adding a // before it and reinstall you will be told what the error is.

Alternatively you can opt not to use the database logging tool and all these issues with not be a factor.

mariocaz

04-20-2009 03:14 AM

Hi again Ted,

Tell me exactly what I have to do, I have to edit the product file ?? and then reinstall it ??

Is not more easy add the table manually ??

mariocaz

04-20-2009 03:17 AM

Or no problem tell me where and what I have to do and I will do it to see the problem and to have your mod working like a charm.

mariocaz

04-20-2009 03:49 AM

Ted,

I checked the prodict file, and the part that you told me to add a // alrady have it in the file that I downloaded here, check it:

Code:

                                // check if mod is already installed

                                

                                $db->reporterror = 0;

                                $lgvtbl = $db->query_first("SELECT COUNT(id) as lgv FROM ". TABLE_PREFIX ." lgv");

                                

                                if (!$lgvtbl['cnt']){

                                        

                                        // create the table                                                                                

                                        $db->query_write("CREATE TABLE ". TABLE_PREFIX ." lgv (

                                                  id smallint(5) 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

                                        ");

                                        

                                        // insert the first record

                                        $db->query_write("

                                                INSERT INTO " . TABLE_PREFIX . "lgv SET 

                                                ipaddress =  '123.456.789.012',

                                                firstaccess  = ". TIMENOW .",

                                                views = 1,

                                                lastactivity = ". TIMENOW ."

                                        ");

                                                                        

                                        echo "<font size=\"1\">Added mySQL Tables</font><br /><br />";

                                        

                                } else {                                        

                                        echo "mySQL table already exists.";                                        

                                }

But maybe I am wrong, just tell me.

Ted S

04-20-2009 04:11 AM

That is not an error.

mariocaz

04-20-2009 03:22 PM

What error? this one?

Code:

Database error in vBulletin 3.7.6:



Invalid SQL:



                        SELECT id,views

                        FROM vblgv AS lgv

                        WHERE lgv.ipaddress = '75.107.208.5';



MySQL Error  : Table 'allreef_inicio.vblgv' doesn't exist

Error Number  : 1146

Request Date  : Sunday, April 19th 2009 @ 12:41:49 AM

Error Date    : Sunday, April 19th 2009 @ 12:41:49 AM

Script        : http://www.all-reefs.com/inicio/showthread.php?t=6157

Referrer      : http://www.reefcentral.com/forums/showthread.php?s=&threadid=1622230

IP Address    : 75.107.208.5

Username      : No Registrado

Classname    : vB_Database

MySQL Version :

Also did you check the product file of your Mod that already have the // that you told me to put ?

Code:

If you comment out the line $db->reporterror = 0; by adding a // before it and reinstall you will be told what the error is.

I don?t have the table lgv, check it here:

http://img178.imageshack.us/img178/4...ltables.th.jpg

Thanx Ted!!

All times are GMT. The time now is 12:40 AM.

Page 32 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.01724 seconds Memory Usage 1,754KB 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 (3)bbcode_code_printable (2)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: