Getting the following on account creation..

Database Error0:
File: lib\dbal\mysql.php
Line: 234

any Idea's

BTW Great Mod this will be a great addition, I might be able to remove my CMS and strip down my server for faster access.

I might be doing somthing wrong but it seems straight forward enuff.

Here is the site if you need to check it out

http://bluesworld.game-host.org/roster

It could be a problem with changes between Roster 2.0.1 and 2.0.2. I have been busy with buying a house and have been neglecting the addon. I will update my server to Roster 2.0.2 and see if it has the same problem. In the mean time if there is any other information you could provide, such as whether you used the registration or application for account creation, as one uses the user class and the other uses the profile class, the later actually does the same as the first and then some. But it seems there is an error trying to save information to the database.

ok I think this is a really silly question, but I really tried to find an answer (without any success):
how can I download this addon??

Someone is talking about a SVN-Repo but I can't find it and the link is broken!

please help me!!

reddragon010 wrote:ok I think this is a really silly question, but I really tried to find an answer (without any success):
how can I download this addon??

Someone is talking about a SVN-Repo but I can't find it and the link is broken!

please help me!!

Well I found the the svn and compiled the addon but seems to be some syntax error when you go to install it. I been looking it up for a few hours now in sql documentation. With no luck yet. The syntax error is somewhere in the underlining text I think INDEX KEY (`uid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;but that still wouldn't fix the database not being able to save properly like the author posted early last month.

Nvm if you look at the previous page of this thread you will find the answer to the syntax error and here I knew it all along when I read it in sql documentation

Code: Select all

Install error in query 64. 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 'KEY (`uid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 11
The query was:
CREATE TABLE `roster_addons_accounts_messaging` ( `msgid` int(11) NOT NULL auto_increment, `uid` smallint(6) NOT NULL, `title` varchar(255) NOT NULL default '', `body` text NOT NULL, `sender` int(11) NOT NULL, `senderLevel` int(11) NOT NULL, `read` int(11) NOT NULL default 0, `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`msgid`), INDEX KEY (`uid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;

reddragon010 wrote:ok I think this is a really silly question, but I really tried to find an answer (without any success):
how can I download this addon??

Someone is talking about a SVN-Repo but I can't find it and the link is broken!

please help me!!

Sorry for the double post. let me answer this better. In order to install this addon you need to head over to wowroster's svn. Here is the link http://www.wowroster.net/websvn/listing.php?repname=roster_addons&path=%2Ftrunk%2Faccounts%2F&sc=1#_trunk_accounts_ or this one I like better because it is easier to view the code within each file http://www.wowroster.net/websvn/listing.php?repname=roster_addons&path=%2Ftrunk%2Faccounts%2F&sc=1#_trunk_accounts_

Now once your there go get a program called jEdit it i simply a free tool for programmers or in our case compilers All you do it create the file structure for the addon called accounts within a folder you create called accounts. You simply open each file in the svn copy the text into jEdit then save it to the folder it needs to go into it. A hint when saving your files click save as, then type the full name of the file for example install.def.php and hit save your all set. Make sure if the author use capital letters to name a file then you use capital letters to name that file. Strictly adhere to the naming conventions. So when your done you should have the exact file structure in your accounts folder as seen on the svn.

But then you have to edit the install.def.php file in accounts\inc\ in three spots once on line 158 use the search button in jEdit and search for INDEX KEY simply replace it with the word KEY and drop the INDEX part of it and do it at line 242 and line 313. You can view line numbers by checking the box line numbers under the view menu.

Hello all! Sorry I've been gone so long. I've been moving, so I've been pretty busy. Luckily I'm almost done getting my development server up and running better than ever! I had made the changes to the install.def.php file and have tried to send it to the SVN, unfortunately the SVN doesn't like my password. I will be setting up a new site where I'll have a link to my addons development versions. Otherwise, final and RC versions will be posted here in the download section. Please bear with me for a while longer while I finish re-organizing, and figure out what's wrong with my SVN access, so I can finally finish the Accounts addon.

Your svn access is based on your forums username and forums password. The first time I tried to reconnect to the svn after our move I was not able to until I made my username start with a capital letter (Anaxent rather than anaxent) hope this helps else let us know so that we can help you fix your access.

SVN access is kinda funky here
It updates only when you log-in or change your password

We implemented this method after we opened the site, so the password on the svn side might not have been updated

Woohoo! Logged out of the site, and back in, and voila! My SVN Commit went without so much as a prompt for my username! Thank you Anaxent and Zanix! As always you guys rock! On with the point of this post, I've committed the change to the install.lib.php for the addon. The commit/changelog now is below.

Accounts v1.9.9.941 [SVN]444:
- Fixed
-- MySQL error on messaging table in install.def.php

I'll try to see if I can get this into beta shortly as the popularity of this addon seems to be growing. For that I'll have to finish the admin stuff and check for loose ends (miscellaneous errors).

cooming soon?
May 23, 2009 now we have june 20... :-/

Xcantion wrote:cooming soon?
May 23, 2009 now we have june 20... :-/

Well, if you'd like to complain, I can make sure it never comes out! I've had alot of IRL stuff happenning, and have been otherwise pre-occupied. I'm one person working on the addon, more people would make it go faster, but likely cause other problems, the addon is useable and in the SVN, most of what's left is fixing up the admin pages. I don't want to see anymore comments on how long the addon is taking! If you don't like it, WRITE YOUR OWN DAMN ADDON!!!

Yeah!

Ive got the Accounts module loaded well so the plugin section says yet I am getting a module does not exist error
http://eonsofstupidity.com/woster

When I enter in the url for the Accounts Main page it says that accounts is not installed. Please try re-uploading the files to your site and try to install the addon from the roster configuration Addon Management page. Ensure that the status is activated after install. Please note any errors it may report. Also be sure to set Roster Auth to Accounts in the main roster configuration, this will ensure the proper use of addon permissions and login with Accounts. After Accounts is installed and functioning, you will want to create an account, do this by clicking a registration link on the login screen, note that where it says group password, you should enter the roster admin group password for an admin account. Please also remember that Accounts is still pre-beta, though most of the bugs are out, some may still exist.

yea sorry about this I had to remove it to run the armorysync addon due to some weird error. However I did for a temporary time re-enable the addon just for you
http://www.eonsofstupidity.com/woster/
it says it installed properly through the addon. However I would like to make note the php I believe they were, when i went to save them from the SVN appeared blank so i created blank sheets with the exact file name. Anyways I pm'd you our admin password as well.