Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.

Infusions Fail

jmonroe - Latest reply on 28-09-2018 03:48 by webhalle

0

jmonroe
jmonroe
I just installed v9 and at the Configure Core System part of the install. I am getting the following error whenever I try to infuse any Infusion. Have PHP 5.6.31 and MySQL 5.6.36

Notice: Field 'link_icon' doesn't have a default value @ INSERT INTO tmag_site_links (link_name, link_url, link_visibility, link_position, link_window, link_order, link_status, link_language) VALUES ('News', 'infusions/news/news.php', '0', '2', '0', '2', '1', 'English'wink in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 187

Notice: Field 'link_icon' doesn't have a default value @ INSERT INTO tmag_site_links (link_name, link_url, link_visibility, link_position, link_window, link_order, link_status, link_language) VALUES ('Submit News', 'submit.php?stype=n', -101, '1', '0', '13', '1', 'English'wink in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 187

Apparently, nothing is being written to the database as I clicked on finish configuration and tried to login, but it states enter a valid username. I checked the users table in the database but no entries exist.
Edited by Chan on 13-11-2017 08:25, 1 year ago

Sort replies by

0

Chan
Chan
Thanks for the report. Will be fixed soonest by this week.

Can I know which version of pf9? Is it the 9.03 from Github?

0

jmonroe
jmonroe
Thanks for the response. I downloaded the 9.0 Stable from the link on the news page, https://www.php-fusion.co.uk/news.php

Top left where it says Download PHP-Fusion 9.0 Here (file id = 588)

0

jmonroe
jmonroe

Quote

Thanks for the report. Will be fixed soonest by this week.

Can I know which version of pf9? Is it the 9.03 from Github?
- by Chan


Can you post an update to this thread once the issue has been resolved? Thanks again!

0

Chan
Chan
If you're using 9.00, then we developer might have gone through a lot of steps since.. the latest build we have is:
Download: https://github.com/php-fusion/PHP-Fusion/archive/9.03.zip

But there are known issues still. https://github.com/php-fusion/PHP-Fusion/issues

0

jmonroe
jmonroe
I will download version 9.03 and see it if will at least install and write to the database. Then I can go from there. Thanks for the reply

0

jmonroe
jmonroe
I have tried to install 9.03 and have the same following errors when trying to infuse during the installation process.

Notice: Field 'link_icon' doesn't have a default value @ INSERT INTO tmag_site_links (link_name, link_url, link_visibility, link_position, link_window, link_order, link_status, link_language) VALUES ('News', 'infusions/news/news.php', '0', '2', '0', '2', '1', 'English') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Field 'link_icon' doesn't have a default value @ INSERT INTO tmag_site_links (link_name, link_url, link_visibility, link_position, link_window, link_order, link_status, link_language) VALUES ('Submit News', 'submit.php?stype=n', -101, '1', '0', '13', '1', 'English') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

0

Chan
Chan
Create a new file called delete.php and place it in your root directory -- same with index.php and maincore.php

File : delete.php
Paste in this code:

require_once "maincore.php";
require_once THEMES."templates/header.php";
dbquery("ALTER TABLE `tmag_site_links` MODIFY COLUMN `link_icon` VARCHAR(100) NOT NULL DEFAULT ''");
print_p("Please delete this file");
require_once THEMES."templates/footer.php";


Upload, Run it once, delete the file.

See if it works.

0

jmonroe
jmonroe
That file did run and gave me the message Please Delete the file.

0

Chan
Chan
Yes, after that you can try install news and see? What we did was to add a default values to link_icon

0

jmonroe
jmonroe
Still doesn't write user and admin details to the database. If I choose to go back to install.php, it brings me to the infusion page. If I click on News, I get the following:

Notice: Duplicate entry 'news_image_readmore' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_image_readmore', '1', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_image_frontpage' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_image_frontpage', '0', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_thumb_ratio' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_thumb_ratio', '0', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_image_link' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_image_link', '1', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_photo_w' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_photo_w', '1920', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_photo_h' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_photo_h', '1080', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_thumb_w' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_thumb_w', '800', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_thumb_h' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_thumb_h', '640', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_photo_max_w' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_photo_max_w', '2048', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_photo_max_h' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_photo_max_h', '1365', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_photo_max_b' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_photo_max_b', '2000000', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_pagination' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_pagination', '12', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_allow_submission' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_allow_submission', '1', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_allow_submission_files' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_allow_submission_files', '1', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_extended_required' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_extended_required', '0', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

Notice: Duplicate entry 'news_file_types' for key 'PRIMARY' @ INSERT INTO tmag_settings_inf (settings_name, settings_value, settings_inf) VALUES('news_file_types', '.pdf,.gif,.jpg,.png,.svg,.zip,.rar,.tar,.bz2,.7z', 'news') in /includes/classes/PHPFusion/Database/Driver/MySQLi.inc on line 201

0

Chan
Chan
What is your Server PHP Version? We have a very wierd situation here.

0

jmonroe
jmonroe
PHP version 5.6.31. I just cleared the db and reinstall. Works with PDO. It installed successfully and I can infuse now.

0

alqutob
alqutob
Today I faced the same problem while installing PHP-Fusion 9.0 on my server http://phpfusion-ar.xyz
and finally I used PDO driver to fix the problem.
PHP version 7.1

0

webhalle
webhalle
I have also problem with installing PHP-fusion 7 , it stoped by creating tabel .. abd that's it..
Actions
You can view all discussion threads in this forum.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.
More topics like this
Participated Users
Users who participated in discussion: :
Chan, jmonroe, alqutob, webhalle

Moderators:
{%user_avatar%}

Infusions Fail
by {%user_profile_link%} {%post_date%}