ok now this is starting to bother me!

I posted this issue on the hackers help forum. So far there hasn't been any conclusive thoughts but I did have a comment form Dark_Wizard, he also says that his database had a problem with these same files also and did this same fix and it worked for him.

I got my fingers crossed on this one. Sounds like it could finaly work for ya.

I am sending you the updated viPortfolio/database/ files. Take the attached zip file and extract the contents into the viPortfolio/database/ directory on your server. this will overwrite all the files in that directory.

Now you can go ahead and rerun the install.

These fixes will also be in version 1.2.3 and above.

Did that...and got the EXACT same message. No change.

Should any of the files be a certain CHMOD that may not be when I upload them?

It wouldn't create the tables? What version of PHP and MySQL are you using?

PHP 4.2.1

Mysql 3.23.45

And yes...it would not get past stage 1 of install...tables could not be created.

Apok2002,
This was definately not in the plans. Did you not read the plans before we started this beta testing. The errors can last more than three days. Your time is up.

I am going to go and fix the error reporting in the install script. Unless I see something that shouts out error there won't be any fixes in the version I send up. It will hopefully just give more exact information about the problem it is having. taht will be posted within the next hour.

For any body else. If you are recieveing the same error you are more than welcome to run this new install and see if you get the same reponses as everybody else. I would really love to find this bug and (Politicaly Correct of course) squash its guts out!

Be back in a bit

When running:

I get 2 usergroups, #'s 45 and 46. So I'm assuming it's safe to use "47" as the high number?

yayyyy! Admin settings finally showed up. But...They are listed 2x. I'm assuming this may have to do somethingw/ my above post. How do I remove one of those entries for viPortfolio Settings in the admin cp?

So you found two entries in the settinggroup table called 'viPortfolio Settings'. One of those settinggroupids you used to assign to the settings in the setting table.

I am going to pick 46 for this example. That would make 45 an extra row.

delete from settinggroup where settinggroupid = 45

This will get rid of the extra row.

This presents me with a question though. How are you getting the settings in the table but not able to create other tables? Is there a permission problem or something that you have on your database? I am guessing you have already validated that. How are you getting the settings into the database. executing something like below:

\. install_settings.sql

from a mysql prompt or

mysqladmin install_settings.sql

from a command prompt?

Either way, I have attached the new install file with the addtional debug messages in it. We should now exactly what, were, why, and who to shoot after you run this.

Thanks

I'm using myphpadmin. I will open install_settings.sql in a web browser/text editor, then copy/paste into myphpadmin.

Perhaps that is the cause? It's the only way I know how to.