[Nirjonadda]

Its not working for me on 4.1.10....any support please.

[Ted S]

Originally Posted by Nirjonadda

Its not working for me on 4.1.10....any support please.

I hate to sound like a broken record but no one can offer you support when the details of your issue are simply "it's not working".

[davidg]

works fine with 4.1.11 and worked with 4.1.10 to

[Robru]

Works fine with 4.2.x

[CubicWebs]

Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.lgv' doesn't exist in [path]/includes/class_core.php on line 1391
Updated ID Field


Warning: mysqli_query() [function.mysqli-query]: (42S02/1146): Table 'habbfeve_sarah.lgv' doesn't exist in [path]/includes/class_core.php on line 1391

Warning: mysqli_query() [function.mysqli-query]: (42000/1064): 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 'TYPE=MyISAM' at line 9 in [path]/includes/class_core.php on line 1391

When I use that additional one you added I get the same error:

Database error in vBulletin 4.2.0:

Invalid SQL:
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;

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 'TYPE=MyISAM' at line 9
Error Number : 1064
Request Date : Thursday, June 7th 2012 @ 10:03:27 PM
Error Date : Thursday, June 7th 2012 @ 10:03:27 PM
Script : http://********/admincp/plugin.php?do=productimport
Referrer : http://********/admincp/plugin.php?do=productadd
IP Address : ******************
Username : ***
Classname : vB_Database_MySQLi
MySQL Version : 5.5.23-55

[Ted S]

Does your mySQL server not use MyISAM?

[CubicWebs]

Originally Posted by Ted S

Does your mySQL server not use MyISAM?

Don't know my mate uses HostGator.

Edit:

(4:50:00pm)Ezekiel K.:Our MySQL servers use innodb instead of MyISAM.

[Ted S]

Originally Posted by CubicWebs

Don't know my mate uses HostGator.

Edit:

(4:50:00pm)Ezekiel K.:Our MySQL servers use innodb instead of MyISAM.

vBulletin has generally assumed MyISAM but this is not a big deal. Simply remove the Type=MyISAM bit leaving ); in the query / xml file.

[CubicWebs]

Originally Posted by Ted S

vBulletin has generally assumed MyISAM but this is not a big deal. Simply remove the Type=MyISAM bit leaving ); in the query / xml file.

Thank you yey

[rosmac54]

Hey Tom great Mod... been using this mod for over 3 years and love it. Great job my friend! Question what do I need to replace to get this to work with registered members. Looking at your code I cannot for the life of me figure this out! I know that non reg is 1 and my registered is 2, could you please let me know where to make these changes in the code and does it also need to be done in MySQL...if so where? Any help would be appreciated. Thanks again.

Ross

[Ted S]

Originally Posted by rosmac54

Hey Tom great Mod... been using this mod for over 3 years and love it. Great job my friend! Question what do I need to replace to get this to work with registered members. Looking at your code I cannot for the life of me figure this out! I know that non reg is 1 and my registered is 2, could you please let me know where to make these changes in the code and does it also need to be done in MySQL...if so where? Any help would be appreciated. Thanks again.

Ross

Tom? We've got an Andrew, a Drew, but no Tom's around here to pass your remarks on to...

As far as your question, if you want to limit how registered members see threads you'd essentially be taking the base code and rewriting the check functionality to switch from guest to a usergroup check. You can find the aproppriate functions in the vBulletin documentation.

[rosmac54]

Thanks for all your smart ass help TED! TEDDY! EDWARD! EDWARDO! UN-Installed. I'll rewrite the whole thing and post it. One word of advice...be very careful who you insult, especially when you have NO IDEA who you are insulting.

[Videx]

Originally Posted by rosmac54

Thanks for all your smart ass help ... be very careful who you insult

I think you have seriously misinterpreted his response if you think that was an insult. The smiley alone shows he's just palling around. Lighten up.

[Ted S]

Originally Posted by rosmac54

Thanks for all your smart ass help TED! TEDDY! EDWARD! EDWARDO! UN-Installed. I'll rewrite the whole thing and post it. One word of advice...be very careful who you insult, especially when you have NO IDEA who you are insulting.

What insult? Now I'm even more confused.

Anyways to each their own. But if you do decide to create a better version of this idea I certainly do hope you share it with the community. That's the point of this all, right?

[iadventure]

I get database error when I try to install on 4.1.12.
I even used the updated one from page one as well. no dice.