Major Additions - VBNow: twitter.com equivalent for vbulletin

ABOUT

This product is in beta

VBNow is a twitter.com like application for vbulletin communities.

It allows members of the community to send updates about moments in their lives just by telling what they actually are doing or planning. It also allows people to add friends and directly access their entries. Friends that are tracked by others are also visible.
The core is formed by the public timeline.

If activated on your forum it includes automated image verification and flood control.

SPECIAL

- image verification is driven by the vbulletin one make sure it's activated in your options
- don't forget to set the usergroup permissions
- don't forget to set the options of VBNow to your liking

INSTALLATION

Installation instructions are included in a pdf in the zip file

CLICK INSTALL

LIVE DEMO

Special Xbox Live version http://www.xboxlivenation.com/community/vbnow.php

CHANGELOG

V 1.0.0. August 22 2007
Initial Release

V 1.0.1. August 22 2007
Fixed broken table

V 1.0.2 August 22 2007
Fixed $pagenav security issue

V 1.0.3 August 22 2007
Imagecheck now an option, different check for availability


CREDITS

This has taken quite some work and still will take a lot more. Please give credit where credit is due. You cannot remove any copyright notice without prior written permission. Instructions are included in the pdf file.

You cannot translate, reproduce or duplicate without prior written permission from the author.

Abuse will be reported

FAQ

The FAQ and configuration instructions are included in the pdf file.

Support for people that have clicked install


Feel free to support this mod and make a paypal donation to admin@stonyarc.com



CLICK INSTALL

(c) 2007 StonyArc

[stonyarc]

Originally Posted by Endurer

I am getting an SQL error:



I ran the installer but it didn't create the table. Should I reimport the product?

Edit: reimport didn't work.

You need to reinstall the product.

For uninstall it so it cleanly drops the tables. Did you accidently drop the table, as that seems to be the only way you can get that error.

[Endurer]

I did a clean install again. The no-permission page came up for the first time. Then I went ahead to usergroup permissions to allow access, rebuilt bitfields, visited the vbnow application and the error is there again. Seems like something is dropping the table or it's not being created at all. Whats interesting to note is that vbnow_friends and vbnow_profile tables are being created. It's just the vbnow table that's causing problems.

[stonyarc]

Originally Posted by Endurer

I did a clean install again. The no-permission page came up for the first time. Then I went ahead to usergroup permissions to allow access, rebuilt bitfields, visited the vbnow application and the error is there again. Seems like something is dropping the table or it's not being created at all. Whats interesting to note is that vbnow_friends and vbnow_profile tables are being created. It's just the vbnow table that's causing problems.

That part hasn't changed since the initial release.

Please uninstall the product and check if there are tables left (shouldn't be, if so drop) before reinstalling. If that doesn't work run the query manually (you need to edit it before being able to run in phpmyadmin)

[Endurer]

I tried to run the query and here's the error that I've received from phpmyadmin:

Error
SQL query:
CREATE TABLE `vbnow` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`itimestamp` int( 11 ) NOT NULL ,
`message` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`url` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`updated` int( 11 ) NOT NULL default '0',
`utimestamp` int( 11 ) NOT NULL ,
`userid` int( 11 ) NOT NULL ,
`views` int( 11 ) NOT NULL ,
`archived` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
KEY `updated` ( `updated` , `userid` , `url` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =2

MySQL said:
#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 'character set utf8 collate utf8_unicode_ci NOT NULL,
`url` v

[stonyarc]

On my server that runs fine. strange

[Endurer]

Yes, it's pretty strange because it's working on my PC too. My MySQL version on server is: 4.0.27-standard

and as per mySQL:

As of MySQL 4.1, character data types (CHAR, VARCHAR, TEXT) can include CHARACTER SET and COLLATE attributes ...

Any alternatives?

[Endurer]

Any solutions stonyarc? I am pretty desperate to get it running on my website.

[stonyarc]

Originally Posted by Endurer

Any solutions stonyarc? I am pretty desperate to get it running on my website.

You can create the tables manually as long as you respect the names and settings but it's strange you are the only one reporting this. Has to be a setting somewhere.

[Sirtis]

very fine hack

[teach1st]

Originally Posted by stonyarc

You can create the tables manually as long as you respect the names and settings but it's strange you are the only one reporting this. Has to be a setting somewhere.

I get the same errors and symptoms as Endurer. Uninstall/reinstall doesn't work (vbnow tables were dropped on uninstall). I get the same errors when trying to manually create the vbnow table. MySQL 4.0.27, vBulletin 3.6.8