MYSQL errors in Fresh install on localhost

Geiri · March 22nd, 2009, 01:34 PM

I get this error after config has been writen and above the forum integration option wich shows like nothing is wrong belove this errors.

Code:

Content visible to verified customers only.

The server specs are
Windows 2008 IIS7
Php 5.2.9 -1
Mysql 5.1.32

Geiri · March 22nd, 2009, 02:01 PM

Could this be becouse Mysql was runing in strict mode?

When trying to setup VBulletin it did give me a warning about mysql in strict mode After I disabled strict mode in mysql I did setup Vbulletin with out any trouble and allso subdreamer cms

I droped my cp_ tables and tried again, I got passt the error but now I get an error when installing lang strings

Code:

Content visible to verified customers only.

Chuck S · March 22nd, 2009, 06:36 PM

YES its because mysql is in strict mode.

THE second notice is a warning your PHP error reporting is set too high your reporting an empty variable which in PHP we know exists all the time till they are filled.

Geiri · March 23rd, 2009, 08:21 AM

The lang strings where not installed into db.
So my install shows up with out any words.

Any idea why?

Chuck S · March 23rd, 2009, 10:02 AM

Code:

Content visible to verified customers only.

can not say did you try rerunning the phrases.php file? This is happening on your local machine not a true webhost right.

Geiri · March 23rd, 2009, 12:51 PM

This is on a local test server.

I have not tried to run the phrases.php yet

Geiri · March 23rd, 2009, 12:58 PM

I did try to run phrases.php but got same error line 21

Then I tried to run upgrade.php and the exact same error came STRING in line 21.

Geiri · March 23rd, 2009, 01:14 PM

I installed Photopost with out a problem I got a small error thou saying my header files where not under the php open base dir. It had no effect and Photoshop is runing fine.

Chuck S · March 23rd, 2009, 02:41 PM

If your having a problem running the upgrade or phrases files you will have a problem running the actual program its balking on the typecast function which is used through out the program

try setting your php error handling to normal on your local server. I bet it installs fine on a properly setup webserver.

Geiri · March 23rd, 2009, 09:18 PM

After some testing and finaly disabling all error reporting in php It allmost worked I get this error now after the install.

Code:

Content visible to verified customers only.

Chuck S · March 23rd, 2009, 10:03 PM

well okay that explains it its not a photopost classifieds file persay.

Its a custompal the custom1pal to be exact which you can enter your own code.

You can try making that template this.

Code:

Content visible to verified customers only.

Geiri · March 24th, 2009, 09:11 AM

That was Right

works like a charm

Chuck S · March 24th, 2009, 10:38 AM

Yeah always having an error to go on goes along way

I would have figured you would have figured out the issue awhile ago. You would have had to physically turn this custompal on after you finished your install where it was up and running.

Thus it had installed fine after you ran install after turning off mysql safe mode.

Geiri · March 24th, 2009, 08:55 PM

Quote:

Originally Posted by Chuck S

Thus it had installed fine after you ran install after turning off mysql safe mode.

I admit I have no deep knowledg in mysql or php but I usually mange

Do you think my MYSQL is runing in safe mode?

Wher can I see that?

I cant see any bindings to any local address and the mysql has TCP/IP enabled and is listening on TCP port 3306

I have just recently setup this server and I am configuring to swap out my 4 year old wich is geting.. old and slow like me

Chuck S · March 24th, 2009, 10:05 PM

STRICT MODE is what I meant you said you turned that off after reading about it in vb.

Zeos · January 30th, 2010, 03:09 PM

strict mode was the problem.. now a new problem....says :

We're sorry, but the system experienced an unrecoverable error. Please try again later.

but no clue as to what it is...

Thank you very much for your help...

Chuck S · January 30th, 2010, 03:11 PM

Try dropping the classifieds tables and reinstalling now that you set strict mode off.