Odd installation issue.

[blackey191]

I don't know why but on my test server when I install TP it gives no errors in the package manager but no blocks are displayed. When I go into admin/manage_blocks and click to add new blocks it errors out around 331. Not sure the exact line, I will have to duplicate when I get home and will update with the error code. It works great on my production system but doesn't on my test system. Current Mysql, 1.1rc2, .86TPrev2, Php5. Maybe someone here can give me an idea as to where to start. This isn't a one time thing since I can reproduce the problem with the same results. I even uninstalled Mysql and SMF and reinstalled. I installed with no mods and again with the SMF patch.

[IchBin]

Check file permissions if you're on a linux host. Are you installing from the default theme?

[agridoc]

PHP 5 could possibly cause some errors with blocks, but I cannot give more on this.

[blackey191]

Here is the error when I click to add a Block. My test system is a windows box running Apache as you can tell from the error. My production system is a Linux box. As for the installation I did it from scratch to make sure. No custom themes no mods. I even tried with and without the 1.1rc2 security patch. I know some PHP but I'm not proficient. Anything is appreciated.

Code Select Expand

Field 'visible' doesn't have a default value
File: C:\Program Files\Apache Group\Apache2\htdocs\smf\Sources\TPortalAdmin.php
Line: 143

Line 143

Code Select Expand

db_query("INSERT INTO {$tp_prefix}blocks (type,title,body,frame,bar,off,access) VALUES(5,'-no title-','-no content-','theme',$newbar,'1','$grps')", __FILE__, __LINE__);

[IchBin]

Could you run the manual_install.php file and see if that fixes it please.

[blackey191]

Ok, tried it 2 different ways. Uninstalled in package manager then copied all TP files from the zip overwriting the old. Then ran the manual_TP_install.php. No errors, still not working. Then ran the sql files install after that still no luck. Reinstalled from package manager to see if it made a difference. No difference. I will try to do it from scratch if you recommend it.