Topic: Installation Help!

[S.T.A.R.S]

Hey Guys.

I can install Simple portal onto my SMF 2.0 forum, once installed nothing changes. I don't see any changes within the admin side of the forum and nothing in the "Modification Settings".

I have always had a problem with Mods, whats up? It did say it had installed.

You can view my forum at www.mmogamer.co.uk

thx for ur help

[Old Fossil]

Did any files have test failed next to them?

[S.T.A.R.S]

No. While the temp file remains active in my "Packages" folder it says test sucessful.

[S.T.A.R.S]

My mistake! However, in the installation an error occures such as:



Any ideas on how to fix this?

thanks!

[Old Fossil]

Gonna have to leave it to the experts.

 

I'd have a look through the forum using the search as I am sure it has been answered before.

[S.T.A.R.S]

Ah ok, thanks for your help.

I hope some experts will come along to this thread, really in need of the help

[Raji]

This is just an idea that worked well for me.

1. Download your SMF's PACKAGES on local machine.
2. Download full version of SMF 2.0. Extract and upload in a different folder
3. Install SMF 2.0 in new folder
4. change database configuration within setting.php as per your old smf.
5. execute repair_settings.php
6. UPLOAD packages within new folder from your local machine.


Every thing will be alright.

[S.T.A.R.S]

4. change database configuration within setting.php as per your old smf.
5. execute repair_settings.php

i dont understand :/ sorry!

[cloksin]

attached is the repair_settings.php file.  Put it in your document root (same place all the smf files are) and then navigate to the file in your browser.  www.yoursite.com/forum/repair_settings.php

[S.T.A.R.S]

What am i supposed to use it for may i ask?

All the settings already are the correct ones :/

[S.T.A.R.S]

still recieve error of

Invalid default value for 'approved'
File: /var/www/vhosts/mmogamer.co.uk/httpdocs/Packages/temp/install2.php
Line: 501

[cloksin]

I believe Raji was telling you to reinstall your forum, giving you the step by step and using the repair_settings.php file to change your settings, I just gave you the file since it appeared you weren't familiar with it.

What other mods do you have installed on your forum?

[S.T.A.R.S]

None. Ive always had a problem with Mods.

All i really want is Simple Portal installed and Facebook Like Mod installed then i would fine.

[cloksin]

do you have any errors on your forum when simple portal is NOT installed?

[S.T.A.R.S]

Nope, everything seems fine.

You can view my forum at www.mmogamer.co.uk

thx

[cloksin]

I saw your forum, but that doesn't tell me if there are any errors in the logs

[S.T.A.R.S]

Ok im on the error log, and there are quite a few :/

Maintenace > Error log

im not very good at using this log but it does show that there is a error of

Apply Filter: Only show the error messages of this URL
http://mmogamer.co.uk/index.php?action=admin;area=packages;sa=install2;package=Simple%20Portal;pid=0
Apply Filter: Only show the errors with the same message
Database Error: Invalid default value for 'approved'
Apply Filter: Only show the errors from this file
File: /var/www/vhosts/mmogamer.co.uk/httpdocs/Packages/temp/install2.php
Line: 501

which shows in code view:

Code: [Select]

481:



if (in_array($real_prefix . $table, $current_tables))
482:



{
483:





$info .= '
484:



<li>"' . $table . '" table exists, updating table structure.
485:





<ul>';
486:
487:





if ($is_utf8)
488:





{
489:







$smcFunc['db_query']('', '
490:









ALTER TABLE {db_prefix}{raw:table}
491:









CONVERT TO CHARACTER SET utf8',
492:









array(
493:











'table' => $table,
494:









)
495:







);
496:





}
497:
498:





foreach ($data['columns'] as $column)
499:





{
500:







if (!isset($column['deprecated_name']) || !$smcFunc['db_change_column']($smf_db_prefix . $table, $column['deprecated_name'], $column))
==>501:









$smcFunc['db_add_column']($smf_db_prefix . $table, $column);
502:
503:







if ($is_utf8 && in_array($column['type'], array('text', 'tinytext')))
504:







{
505:









$smcFunc['db_query']('', '
506:











ALTER TABLE {db_prefix}{raw:table}
507:











CHANGE {raw:name} {raw:name} {raw:type} CHARACTER SET utf8',
508:











array(
509:













'table' => $table,
510:













'name' => $column['name'],
511:













'type' => $column['type'],
512:











)
513:









);
514:







}
515:





}
516:
517:





$info .= '
518:







<li>Table columns updated.</li>';
519:
520:





// This isn't necessary and causes trouble for RC4!
521:





if ($forum_version != 'SMF 2.0 RC4')

First time using this log so i dont have alot of knowledge about it :/

thanks

[S.T.A.R.S]

anyone know why that error occures?

[[SiNaN]]

Continue from this topic:

http://simpleportal.net/index.php?topic=9069.0