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

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.
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?
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)

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!
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
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
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
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:
CodeDownload  

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.
That file did run and gave me the message Please Delete the file.
Yes, after that you can try install news and see? What we did was to add a default values to link_icon
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
What is your Server PHP Version? We have a very wierd situation here.
PHP version 5.6.31. I just cleared the db and reinstall. Works with PDO. It installed successfully and I can infuse now.
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
I have also problem with installing PHP-fusion 7 , it stoped by creating tabel .. abd that's it..
Thread Information
Author
Replies
15 posts
Views
2,237 times
Last Post
Last updated on 2 years ago
You can view all discussion threads in this forum.
You cannot set up a bounty in this discussion thread.
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.
You cannot up or down-vote on the post in this discussion thread.
Users who participated in discussion: Chan, jmonroe, alqutob, webhalle