Token Chooser SQL Error

[rsarver]

Hello,

What a great application!! I'm a newby who just downloaded the app and I'm experiencing a slight problem. I've created a builder page with a single repeater to a single table in a database outside of the FB installation database -- yet still on the same server. In the repeater Data Source Area I have all the correct information to (e.g. host, schema, user and password). After using the wysiwyg editor to pull-in a 3-column template, I click on the Token Chooser to bring up the code I'll need to copy into the template fields, but, the template chooser doesn't come up. Instead I get a sql error box saying "access denied" -- the usual thing you get when one of your connection parameters is not correct.
So, I manually enter the text that the chooser would have inserted and to my surprise repeater works fine, showing the records in the table that the Token Chooser should have accessed.
I've seen all the videos, read everything I can find on the site, and, re-created the situation again and again. I figured it's time to ask the experts.
Thanks!

[admin]

Ah, excellent find, thank you for bringing this up.

It turns out pre PHP 5.3 MySQLi handles errors differently than PDO (e.g., not as gracefully), which meant that the connection info wasn't being passed correctly to the database server, which is why your designated connections failed.

I have just patched this and released a new build to the download area.

This should solve the issue nicely.

Sorry about the trouble though, hopefully you'll have smooth sailing from here on out : )

[rsarver]

Thanks! The problem persists. This was my first time upgrading and hopefully I did the upgrade correctly. According to your video, I needed to copy my:
<live server>/formboss/app/config.php TO
<unzipped>/formboss/app/
AND
<live server>/formboss/app/movefiles/config.php TO
<unzipped>/formboss/app/movfiles/

Then remove <live server>/formboss/app folder and copy:
<unzipped>/formboss/app TO
<live server>/formboss/

Please let me know what I'm doing wrong and why the I'm still having this problem. I'm running this on an OpenSuse platform with the following:
apache2-2.2.4-70.11
mysql-5.0.45-22.9
php5-mysql-5.2.11-0.1

Thanks!

[admin]

Greetings,

Thank you for the update. No luck huh. No problem, let's dig a bit deeper...

First, your update process looks perfect...and in fact OpenSUSE 11.2 is what i did my testing on last night...

Quick question then...are you using the PDO or the MySQLi extension? You can find this in the config files or if you an recall from the installer. If you cannot recall, in the app/config.php file you will see:

Code: Select all

define('DB_TYPE', 'mysql');

for PDO and:

Code: Select all

define('DB_TYPE', 'mysqli');

For MySQLi

The part I fixed last night was for MySQLi...though I suspect you may be using PDO.

No matter, I've done a few more tests using two boxes, Vista 64 and OpenSUSE 11.2. First I test each box for a faulty local connection, then when trying to go from:

SUSE->Windows
Windows->SUSE

In both cases, and with both drivers (MySQLi and PDO), the error info works fine should I provide faulty info--of course what it should be doing for you...

Thus, I wonder if the update process may have failed. Your description sounds fine, but perhaps the files somehow reverted.

The good news is the only file that needed to be updated was:

updated-file.png (73.51 KiB) Viewed 1919 times

If you don't mind, perhaps you could check the date as see if it matches my screen shot?

Please keep me posted,

Matt

[rsarver]

Thanks for the help. My config shows:
define('DB_TYPE', 'mysql');

I tried switching it to mysqli and got a different error about not being able to contact the database. Is there a mysqli package that must be installed on the server?

Here's the Database.php file as it sits on the server:
-rw-r--r-- 1 root root 20235 Jan 19 21:40 Database.php

Except for the mysqli situation, it would appear everything else is in line.

Thanks again for your help!

P.S. do you do any consulting with this product? I think I would be interested in contracting your help to customize your product for our school district, or, at least provide some instruction of how we could use your application for some of the projects we have. If you don't mind, please contact me at rsarver@troy30c.org

[admin]

Hmmm. How about this, I will email you right now, that way we can get a bit more detailed with the exact error messages and login details. Just to be clear, the part where I said I fixed something was only with regard to the MySQLi extension, which you are not using.

Emailing away!

[Tempest]

EDIT* I think I solved it for anyone else having the same issue I removed mysqli from the "DB Connector File (relative to job folder)" box
not sure why I had that in there or if it needs to be there, but that fixed it??

Hi guys,
I too am experiencing the same issue with the Token Chooser, when running with an external dbase, (hosted on the same server)
when clicking on the chooser i get
" CONNECTOR ERROR - The Specified Connector Script Cannot Be Found.

Please check the file path and correct as needed.
Also note you need to save your job at least once for this feature to work."
The job is saved well and im using the mysqli connection,
# Build 685 (FormBoss 2) 6.30.10 #
Appreciate all help
thanks
Steve

fb_error.jpg (115.93 KiB) Viewed 58 times

[admin]

Interesting news, thank you for the update.

Yes, the connector name should just be the path to a PHP file, perhaps we had extra characters and the like.

Hopefully all is well though, please let me know if not!