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.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 9 Support
  4. Installation Issues- 9
  5. Infusions Fail

Infusions Fail

Asked Modified Viewed 3,881 times
Back to Forum Index Previous Topic Next Topic
Print
J
jmonroe
J
  • Junior Member, joined since
  • Contributed 41 posts on the community forums.
  • Started 9 threads in the forums
  • Started this discussions
asked
Junior Member

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 10:25,
0 replies

14 posts

C
Chan
C
Chan 0
Lead Developer of PHP-Fusion
  • Super Admin, joined since
  • Contributed 3,841 posts on the community forums.
  • Started 232 threads in the forums
  • Answered 6 questions
answered
Super Admin

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 replies
J
jmonroe
J
  • Junior Member, joined since
  • Contributed 41 posts on the community forums.
  • Started 9 threads in the forums
  • Started this discussions
answered
Junior Member

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 PHPFusion 9.0 Here (file id = 588)
0 replies
J
jmonroe
J
  • Junior Member, joined since
  • Contributed 41 posts on the community forums.
  • Started 9 threads in the forums
  • Started this discussions
answered
Junior Member

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 replies
C
Chan
C
Chan 0
Lead Developer of PHP-Fusion
  • Super Admin, joined since
  • Contributed 3,841 posts on the community forums.
  • Started 232 threads in the forums
  • Answered 6 questions
answered
Super Admin

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/PHPFusion/PHPFusion/archive/9.03.zip

But there are known issues still. https://github.com/PHPFusion/PHPFusion/issues
0 replies
J
jmonroe
J
  • Junior Member, joined since
  • Contributed 41 posts on the community forums.
  • Started 9 threads in the forums
  • Started this discussions
answered
Junior Member

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 replies
J
jmonroe
J
  • Junior Member, joined since
  • Contributed 41 posts on the community forums.
  • Started 9 threads in the forums
  • Started this discussions
answered
Junior Member

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 replies
C
Chan
C
Chan 0
Lead Developer of PHP-Fusion
  • Super Admin, joined since
  • Contributed 3,841 posts on the community forums.
  • Started 232 threads in the forums
  • Answered 6 questions
answered
Super Admin

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:
Code Download source

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 replies
J
jmonroe
J
  • Junior Member, joined since
  • Contributed 41 posts on the community forums.
  • Started 9 threads in the forums
  • Started this discussions
answered
Junior Member

That file did run and gave me the message Please Delete the file.
0 replies
C
Chan
C
Chan 0
Lead Developer of PHP-Fusion
  • Super Admin, joined since
  • Contributed 3,841 posts on the community forums.
  • Started 232 threads in the forums
  • Answered 6 questions
answered
Super Admin

Yes, after that you can try install news and see? What we did was to add a default values to link_icon
0 replies
J
jmonroe
J
  • Junior Member, joined since
  • Contributed 41 posts on the community forums.
  • Started 9 threads in the forums
  • Started this discussions
answered
Junior Member

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 replies
C
Chan
C
Chan 0
Lead Developer of PHP-Fusion
  • Super Admin, joined since
  • Contributed 3,841 posts on the community forums.
  • Started 232 threads in the forums
  • Answered 6 questions
answered
Super Admin

What is your Server PHP Version? We have a very wierd situation here.
0 replies
J
jmonroe
J
  • Junior Member, joined since
  • Contributed 41 posts on the community forums.
  • Started 9 threads in the forums
  • Started this discussions
answered
Junior Member

PHP version 5.6.31. I just cleared the db and reinstall. Works with PDO. It installed successfully and I can infuse now.
0 replies
A
alqutob
A
PHP-FUSION ARABIC SUPPORT
http://phpfusion-ar.xyz 
  • Member, joined since
  • Contributed 96 posts on the community forums.
  • Started 39 threads in the forums
answered
Member

Today I faced the same problem while installing PHPFusion 9.0 on my server http://phpfusion-ar.xyz
and finally I used PDO driver to fix the problem.
PHP version 7.1
0 replies
— 2 months later —
W
webhalle
W
  • Newbie, joined since
  • Contributed 1 post on the community forums.
answered
Newbie

I have also problem with installing PHP-fusion 7 , it stoped by creating tabel .. abd that's it..
0 replies

Category Forum

Installation Issues- 9

Labels

None yet

Statistics

  • Views 0 views
  • Posts 14 posts
  • Votes 0 votes
  • Topic users 4 members

4 participants

C
C
Chan 0
Lead Developer of PHP-Fusion
  • Super Admin, joined since
  • Contributed 3,841 posts on the community forums.
  • Started 232 threads in the forums
  • Answered 6 questions
J
J
  • Junior Member, joined since
  • Contributed 41 posts on the community forums.
  • Started 9 threads in the forums
  • Started this discussions
A
A
PHP-FUSION ARABIC SUPPORT
http://phpfusion-ar.xyz 
  • Member, joined since
  • Contributed 96 posts on the community forums.
  • Started 39 threads in the forums
W
W
  • Newbie, joined since
  • Contributed 1 post on the community forums.

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet