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.
jmonroe

Infusions Fail

by jmonroe, Last updated on 1 year ago in Installation Issues- 9
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.
KreativMind
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?
Lead Developer of PHP-Fusion
Developer Tweet: https://twitter.com/phpfusion_tweet
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)
KreativMind

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!
KreativMind
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
Lead Developer of PHP-Fusion
Developer Tweet: https://twitter.com/phpfusion_tweet
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
KreativMind
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
KreativMind
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.
Lead Developer of PHP-Fusion
Developer Tweet: https://twitter.com/phpfusion_tweet
That file did run and gave me the message Please Delete the file.
KreativMind
Yes, after that you can try install news and see? What we did was to add a default values to link_icon
Lead Developer of PHP-Fusion
Developer Tweet: https://twitter.com/phpfusion_tweet
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
KreativMind
What is your Server PHP Version? We have a very wierd situation here.
Lead Developer of PHP-Fusion
Developer Tweet: https://twitter.com/phpfusion_tweet
PHP version 5.6.31. I just cleared the db and reinstall. Works with PDO. It installed successfully and I can infuse now.
KreativMind
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
PHP-FUSION ARABIC SUPPORT

http://phpfusion-ar.xyz
I have also problem with installing PHP-fusion 7 , it stoped by creating tabel .. abd that's it..
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.
Users who participated in discussion: Chan, jmonroe, alqutob, webhalle