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.
Posted by Catzenjaeger Last replied by Catzenjaeger 2 months ago

SQL error help needed

Hi in my infusion i get a error when i post texts in a textfield as Item decription

Quote

PDOMySQL.inc
/site/infusions/figurelib/admin.php?aid=xxxxxxxxxxx§ion=items&action=edit&item_id=926&step=7

Severity : Notice generated by user using trigger_error() function
Query Error: UPDATE `fusionSL2JP_figure_items` SET `figure_title` = 'Neomorph Life-Size Head', `figure_artists` = 'CoolProps has created a replica of this creature&
#039;s head in life-size with the cooperation of Odd studio, who produced the original prop for the film.', `figure_series` = '', `figure_variant` = '', `figure_weight` = 'TBD', `figure_editionsize` = '', `figure_pubdate` = '2019-3-1', `figure_videourl` = '', `figure_images_source` = '', `figure_credits` = '', `figure_brand` = '9', `figure_category` = '2', `figure_class` = '2', `figure_country` = '206', `figure_manufacturer` = '14', `figure_material` = '16', `figure_poa` = '2', `figure_packaging` = '4', `figure_certificate` = '3', `figure_limitation` = '3', `figure_numbered` = '3', `figure_signature` = '2', `figure_width` = '64', `figure_height` = '21', `figure_depth` = '78', `figure_scale` = '2', `figure_status` = '4', `figure_color` = '10', `figure_hand_cast` = '3', `figure_hand_painted` = '1', `figure_hand_finished` = '1', `figure_retailprice` = '1199.00', `figure_usedprice` = '0.00', `figure_accessories` = '', `figure_description` = 'Sideshow and CoolProps are pleased to present the Neomorph Life-Size Head Prop Replica. The Neomorph appeared in the dark in Alien: Covenant, and attacked the covenant crew continuously with its quick movement. Though this alien has a creepy emotionless face, at its confrontation with David, it almost looked as if the Neomorph showed human expression. CoolProps has created a replica of this creature's head in life-size with the cooperation of Odd studio, who produced the original prop for the film.', `figure_manufacturer_item_id` = '903719', `figure_upc` = '', `figure_ean` = '', `figure_jan` = '', `figure_isbn` = '', `figure_itf14` = '', `figure_asin` = '', `figure_ebay_item_id` = '', `figure_affiliate_various_1` = '', `figure_affiliate_various_2` = '', `figure_affiliate_various_3` = '', `figure_affiliate_various_4` = '', `figure_affiliate_various_5` = '', `figure_affiliate_various_6` = '', `figure_affiliate_various_7` = '', `figure_affiliate_various_8` = '', `figure_affiliate_various_9` = '', `figure_affiliate_various_10` = '', `figure_related_01_url` = '', `figure_related_02_url` = '', `figure_related_03_url` = '', `figure_related_04_url` = '', `figure_related_05_url` = '', `figure_related_01_text` = '', `figure_related_02_text` = '', `figure_related_03_text` = '', `figure_related_04_text` = '', `figure_related_05_text` = '', `figure_show_images` = '1', `figure_show_data` = '1', `figure_show_videos` = '1', `figure_show_affiliates_various` = '1', `figure_show_affiliates_amazon` = '1', `figure_show_affiliates_ebay` = '1', `figure_show_related` = '1', `figure_show_collection` = '1', `figure_show_comments` = '1', `figure_show_ratings` = '1', `figure_show_social_sharing` = '1', `figure_freigabe` = '1', `figure_draft` = '0', `figure_draftstep` = '13', `figure_visibility` = '0', `figure_timestamp` = '1533105957', `figure_language` = 'English', `figure_submitter` = '1', `figure_clicks` = '66', `figure_trash1` = '', `figure_trash2` = '', `figure_trash3` = '', `figure_trash4` = '', `figure_trash5` = '', `figure_trash6` = '', `figure_trash7` = '', `figure_trash8` = '', `figure_trash9` = '', `figure_trash10` = '', `figure_trash11` = '', `figure_trash12` = '', `figure_trash13` = '', `figure_trash14` = '' WHERE `figure_id`='926'
Stack Trace:
#0 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/includes/classes/PHPFusion/Database/Driver/PDOMySQL.inc(64): PDO->prepare('UPDATE `fusionS...')
#1 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/includes/classes/PHPFusion/Database/AbstractDatabaseDriver.inc(312): PHPFusion\Database\Driver\PDOMySQL->_query('UPDATE `fusionS...', Array)
#2 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/includes/db_handlers/all_functions_include.php(113): PHPFusion\Database\AbstractDatabaseDriver->query('UPDATE `fusionS...', Array)
#3 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/includes/sqlhandler.inc.php(810): dbquery('UPDATE `fusionS...')
#4 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/infusions/figurelib/admin/figurelibBackendItems.class.php(514): dbquery_insert('fusionSL2JP_fig...', Array, 'update')
#5 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/infusions/figurelib/admin/figurelibBackendItems.class.php(1230): figurelibBackendItems->handlePostedData()
#6 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/infusions/figurelib/admin/figurelibBackendItems.class.php(88): figurelibBackendItems->displayForm()
#7 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/infusions/figurelib/admin/figurelibBackendView.class.php(106): figurelibBackendItems->viewBackend()
#8 /var/www/vhosts/xxxxxxxxxxxxx.com/httpdocs/site/infusions/figurelib/admin.php(132): figurelibBackendView->viewContent()
#9 {main}
Error Nature: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's head in life-size with the cooperation of Odd studio, who produced the origina' at line 1


code

Code
if (!@function_exists("FLIB_Backend_ItemsForm_Step7")) {
   function FLIB_Backend_ItemsForm_Step7($informations) {
      ?>
      
      
      

         


            
                            array_merge(["placeholder" => $informations['locale']['fieldplaceholder-1801']], $informations['textarea'])
            ); ?>

            
                            array_merge(["placeholder" => $informations['locale']['fieldplaceholder-1802']], $informations['textarea'])
            ); ?>
            
      
         

      

      
          }
}
72 views 0 votes
1 post
Posted by ikandi Last replied by ikandi 2 months ago

Image Resizing (BBCode, Forums)

Hello all,

One of the things I am hoping to achieve on PHP9's Forums is the ability to resize images using the [IMG] BBcode/tag.
I used to run a Dokuwiki site (with Bootstrap 3 framework), and users were able to easily change the dimensions of image display using code such as this:

Code
{{:coverart:image.jpg?300}}


The ?300 being interchangeable to whatever pixel dimension.

Now my users are asking for the same thing in PHP9.

On some other PHPBB websites, the image resizing function is available, say by using code like this:

Code
[img width=300 height=300]image url[/img]


I know there's a few pages on phpbb.com about this, but unsure how it would be applied to PHP Fusion.

If anyone is able to chip in with a solution, that would be great.

Thanks.
Ikandi
154 views 0 votes
1 post
Posted by afoster Last replied by BatPower 2 months ago

External Wrapper

All previous versions of php-fusion has an external wrapper infusion that allowed existing pages to be part of the CMS. Is there such an infusion for version 9 and if not, can the existing one be adapted for version 9?
762 views 0 votes
18 posts
Posted by matsta1 Last replied by matsta1 2 months ago

Dynamic Menu addon

Hi All,
I running version 7.2.xx and recently downloaded and infused the Dynamic Menu addon https://www.php-fusion.co.uk/infusions/addondb/index.php?addon_id=99
I have had a message appear in the Dynamic Menu panel on the left "Table 'cfawdor1_web.fusion88p76_ny_dm' doesn't exist

Any ideas how I fix this?
119 views 0 votes
5 posts
Posted by Tilly Last replied by Tilly 2 months ago

Change from HTTP to HTTPS locks account registration !??

Admin - Settings - Main - Change from HTTP to HTTPS, locks account registration!?

With http web site setting under MAin seting and Admin has to verify new accounts registration works fine

With https web stie setting New User is registered in DB but will not show upp as new user at website after change from http to https under Main settings. Now https autoamatic change Website setting to e-mail verification On and sends e-mal to the new member with link what not work!?

I use PHP-Fusion 7.02.07

How works the http vs https funktion under Main settings and why affect this registration of new user accounts??
327 views 0 votes
9 posts
Posted by Wanabo Last replied by Rudios 2 months ago

What version is .co.uk running now?

Noticed that php-fusion.co.uk was in maintenance mode for a couple of days.

Does this mean this site is now running on v9?

Anyway I like the new look. Starting a new thread gives an option "Forum Tags", but this does nothing.
348 views 0 votes
17 posts
Posted by Last replied by Chan 2 months ago

[Request] Forum medals and reputation

Hi everyone,
I'd like to create a website for anime fans (anime news and anime discussions). I need medals and reputation mods for my forum.
Also, does anyone know where I can find themes for v9?

Thank you :)
107 views 0 votes
2 posts
Posted by Last replied by Chan 3 months ago

Site Update/Maintenance: User Feedback & Support

How do you like the progress on the site updates and features? If you have any comments, or feedback, or questions, kindly drop us a holler.

Thank you.

Management Team.
267 views 0 votes
1 post
Posted by matsta1 Last replied by matsta1 3 months ago

Jpg's not showing in photogallery

Hi everyone,
I am having a little trouble with the photo gallery in v7.02.07.

I have loaded everything as per instructions but for some reason don't seem to be able to get the actual photo to appear on the page, all I get is a small box with an x in it along with the file name. http://www.cfa4wd.org/photogallery.ph...album_id=5
This used to work fine until i attempted the V9 upgrade (unsuccessfully)

(Very amature when it comes to code etc.)
Cheers
Matt
222 views 0 votes
3 posts
Posted by squirlybc Last replied by Falk 3 months ago

An Error I can't understand

Hi,


When I try to access my site http://ybc-llc.com I get the error below:

"Fatal error: Can't use function return value in write context in /home/www/ybc-llc.com/includes/theme_functions_include.php on line 116"



I have the latest PHP fusion 9.0 version of the application. Can this be fixed?
143 views 0 votes
2 posts
Posted by smokeman Last replied by douwe_yntema 3 months ago

DeLuxe Dropdown Menu v1.2

www.php-fusion.co.uk/infusions/marketplace/uploads/image/t_1292.pngNAME:
-----
DeLuxe Dropdown Menu V1.2


AUTHOR:
-----------
Name: Robert Holm (Smokeman)
Email: smokeman@esenet.dk
Web: http://www.phpfusion-tips.dk/


DESCRIPTION:
------------------
A fancy horizontal Dropdown Menu for your PHP-Fusion website.

It has 3 submenus / levels.

Insertion of links from the infusions administration-part.
- No need to edit codes.

Will work with all your standard-coded themes on the site.

100% valid XHTML 1.0 & CSS 2.1


COMPATIBLE WITH:
------------------------
- PHP-Fusion V7.02.XX
- PHP-Fusion V7.01.XX
- PHP-Fusion V7.00.XX


FEATURES:
-------------
- Drop Down with 3 submenus / levels.

- Design & built your own menu or choose from one of the Pre-Installed templates.
- Ability to download several ready-made templates / designs.

- JS Color Picker implemented. Easy & Quick selection of colors / background colors - No need to "know" the color codes. ( See screenshot "Userdefined Template" )

- Compatibility for servers running both PHP4 & PHP5.

- Ability to specify the background color on all 3 submenus.
- Ability to specify border color on all 3 sub-menu's.
- Ability to specify border color on all 3 sub-menu's by mouse-over.

- Ability to use images / icons on all menu items & menu links.
- Ability to use BB codes on all menu items & menu links.

- Ability to specify the background color on all links and menu items.
- Possibility to specify background image on all links and top-menu items.

- Ability to open up links in a new window.
- Ability to set permissions on all links. Ie; you can hide links for example guests - as we know it from the normal built-in links system in PHP-Fusion.
- Ability to move up / down on the already established links.

- Possibility to specify background image on the main menu.
- Possibility to specify background image on the main menu by mouse-over.

- Ability to specify the background color on the main menu.
- Ability to specify the background color on the main menu by mouse-over.
- Ability to specify the background color on submenus.
- Ability to specify the background color on submenus by mouse-over.

- Possibility to specify text color on the main menu.
- Possibility to specify text color on the main menu by mouse-over.
- Possibility to specify text color on submenus.
- Possibility to specify text color on submenus by mouse-over.

- Ability to specify the width on the submenu items.

- Possibility to specify text format on the main menu.
- Possibility to specify text format on the main menu by mouse-over.
- Possibility to specify text format on the submenus.
- Possibility to specify text format on the submenus by mouse-over.

- Possibility to specify text size. Applies to head + submenus.
- Possibility to specify text location. Applies to head + submenus.
- Ability to specify font type. Applies to head + submenus.

- Plus other non-mentioned features ...


INSTALLATION:
-------------------
1. Upload the content of the map "files" to the root of the server.

2. Log on to the site and go to: Admin Panel ==> System Admin ==> Infusions - and install the new infusion: DeLuxe Dropdown Menu.

3. Then go to: Admin Panel ==> System Admin ==> Banners - and insert the following code inte the field "Banner1" or "Banner2":

echo "\n\n
\n\n
\n";
include INFUSIONS."deluxe_dropdown_menu/menu.php";
echo "
\n";
?>

3a: If you want the menu to be centered then use this code instead:

echo "\n\n
\n\n
\n";
include INFUSIONS."deluxe_dropdown_menu/menu.php";
echo "
\n";
?>

4. Administration from: Admin Panel ==> Infusions ==> DeLuxe Dropdown Menu.


UNINSTALLATION:
----------------------
1. Log on to the site and go to: Administration ==> System Admin ==> Infusions - and deactivate the infusion: DeLuxe Dropdown Menu.

2. Then go to: Administration ==> System Admin ==> Banners - and remove the code for the DeLuxe Dropdown Menu.

3. Last you should delete the following map from the FTP: /infusions/deluxe_dropdown_menu


CHANGELOG:
----------------
V1.2 - SQL-Optimization by Flemming (flj) - the menu now use only one single SQL-Query

V1.1 - Added compatibility for PHP-Fusion V7.00.XX and V7.01.XX

V1.0 - First release



Enjoy!

Smokeman | PHPFusion-Tips.dk



-- View this Addon --
11998 views 0 votes
12 posts
Posted by Last replied by zizub 3 months ago

How can I reduce the Waiting (TTFB) time in PHP-Fusion 9.xx

I have installed PHP-Fusion 9.0.3 Andromeda with github. I know that this version is intended for development only. However, I decided to ask: How can I reduce the Waiting (TTFcool time in this version of cms PHP-Fusion 9.03? Maybe there is some special and quick solution to this problem? Or need to analyze and to do everything in the complex, correcting various files and requests?
I have only the video plug-in is installed on the site. The cat_id = 1 page loads for a very long time. I think that the problem is not in the plugin but somewhere in the SMS kernel it is necessary to search. The site can be viewed at: lightxx.ru
Maybe I'm wrong about something. Any advice how to speed up the loading of the page, maybe someone has solved this problem for themselves.
610 views 1 vote
11 posts
Posted by ikandi Last replied by Chan 3 months ago

Search.php - error searching for Articles

Currently, there is an error when using search.php to generates searches by Articles.
It's only the Articles section which is incorrect. Forums and News seem to be ok.
The issue seems to be two slashes are created in the URL, when the search results are generated from PHP Fusion's native Search box.

[BASE URL]/infusions//articles/articles.php?article_id=111111&sref=search

To fix it, go to to:

Code
/includes/search/search_articles_include.php


Go to Row/Line 97

Code
'{%item_url%}' => INFUSIONS."/articles/articles.php?article_id=".$dat


Remove the Slash before first articles string:

Code
'{%item_url%}' => INFUSIONS."articles/articles.php?article_id=".$dat


Should work fine after that.
If Developers could change this in the source code please.

Thanks.
Ikandi
210 views 0 votes
2 posts
Posted by matsta1 Last replied by Chan 3 months ago

Errors Errors

Hi,
Just wondering if someone could please help me?
I have recently tried to update from Fusion_php 7 to php 9 and have had nothing but troubles. It started when I uploaded the files to the server and then ensured the files and folders had the correct access. I then entered my sites url with /install.php after it.
All was going well until I didn't get all passes on the file check. After I exited the page to fix the issues I now get an Internal Server Error 500 and haven't been able to fix it.

I have a number of errors logged in my server log but unfortunately I am very amateur and don't know how to fix them.

PHP Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home2/cfawdor1/public_html/infusions/downloads/downloads.php on line 39

PHP Parse error: syntax error, unexpected T_STRING in /home2/cfawdor1/public_html/infusions/downloads/downloads.php on line 39

$dl_settings = get_settings("downloads");
Line 39 = \PHPFusion\BreadCrumbs::getInstance()->addBreadCrumb([
'link' => INFUSIONS.'downloads/downloads.php',
'title' => \PHPFusion\SiteLinks::get_current_SiteLinks("infusions/downloads/downloads.php", "link_name")



PHP Parse error: syntax error, unexpected T_STRING, expecting T_CONSTANT_ENCAPSED_STRING or '(' in /home2/cfawdor1/public_html/maincore.php on line 18
Line 18 = use PHPFusion\Authenticate;


I have checked the files against the ones in the original files and they are all as per download.

Please help
Matt
339 views 0 votes
4 posts
Posted by Chan Last replied by Chan 3 months ago

Atom-X Theme

The Atom-X Theme is a SDK theme framework that introduces customisable template which overrides core defaults rendering. Along with the initial version of the package, we also bundled some features which had been addressed and developed for Php-Fusion 8, which includes Fusion Dynamics (micro version), select2 plugins, entypo icons, and Bootstrap.

Initial template included:

- Admin Control Panel,
- Dashboard,
- News,
- Private Message,
- Profile and
- Forum.



-- View this Addon --
65535 views 0 votes
218 posts
Posted by matsta1 Last replied by Chan 3 months ago

Images and BB Codes not showing in Admin Panel

HI Everyone,
I am desperate for some assistance if possible. I have loaded v7.02.07 and successfully set it up on my server. The problem being that when I go to the admin panel none of the images are showing and some of the links appear twice (just over the top of each other).
If I hover my mouse over the area where the image is supposed to be it has the same info after the link details aid=1aff566615b6979c
for example; /administration/members.php?aid=1aff566615b6979c

Also none of my BB Codes are showing either??????

Please help :o
Matt
271 views 0 votes
2 posts
Posted by Ankur Last replied by outlaw16151 3 months ago

SEO-Fusion

www.php-fusion.co.uk/infusions/addondb/img/addon_logo.pngSEO-Fusion v1.00

About:

SEO URLs for PHP-Fusion: This Infusion will change your website URLs into descriptive SEO URLs.
In short, this is an Infusion to make your website SEO Friendly.

Features:
  • Easy to Install and Configure
  • Two Templates available (.html or plain)
  • Easy to make changes in URL


Live Demo 1: http://ankurthakur.co.cc/news.html
Live Demo 2: http://fusion8.co.cc/news



-- View this Addon --
65535 views 0 votes
141 posts
Posted by Falk Last replied by outlaw16151 3 months ago

VArcade

www.php-fusion.co.uk/infusions/marketplace/uploads/image/1041.jpg


* Supporting 4 scoring methods, IPB, PHPBB2, vbProArcade,IPB v32
* Automated tournament system that saves highscores & displays latest tournaments with winners.
* Automated game size detection for games with new embedding routines.
* Dynamic zoomability, (users can resize the game window in real time).
* Ads/info pre-loader that can be displayed before each game.
* Users have their own personal favorite system & easy access & managing from the Arcade index.
* Users can send neat game tips to friends.
* Users can report nonfunctional games.
* Users Comment every game (uses Fusions comment table type (G).
* Users can click on a Hi-Score holders name in a game to see all existing Hi-scores.
* Reversed scoring feature, (Yes, it works!).
* Hi-Scores will be sent as a message to a member when their Hi-Score is beaten and a neat sound is played when you take the Hi-score.
* A new PHP-Fusion style listings when browsing games with options from settings.
* Fast Ajax search function that will list hits just as they would be shown in category browsing.
* Games can be turned Off / On when testing and evaluating, they will be found in the Parked area in the admin section.
* Fusions own group access system can be applied to individual games and/or to whole categories. If a game that is public is listed in a category that have custom group status it will not work either.
* Administrators have an easy & quick admin access for the games when browsing, which wont re-load page or relocate you when new values is being saved.
* Game size can be shown in the top right corner.
* Ajax 5 star voting system.
* Randomize game function, for people who just can t decide!
* Allow or disallow guests to play, with nice redirects to make them register or to keep playing anonymous.
* Allow gamers to either play in popup or embedded mode or selectable when browsing.
* User gold support (pay to play).
* Keep alive function (Players who play will stay online)
* Almost all user & automated features are optional, everything can be On or Off very easy via the settings page.
* Games mega center panel
* Games events panel
* When upgrading you can run a simple upgrade script if you want to keep records & stats from your old Arcade.

And much more!

You can see the latest version concept sites on http://www.venue.nu and http://nextarcade.nu



-- View this Addon --
4657 views 0 votes
9 posts
Posted by Ankur Last replied by outlaw16151 3 months ago

Weblinks Websnapr Panel

www.php-fusion.co.uk/infusions/addondb/img/screenshots/t_851.pngThis is my First Infusion to PHP-Fusion smile

This is a Panel which will Display Latest 5 Web-Links from Weblinks with their Snapshots from websnapr.com.

Options
- Choose Image Size 202 or 90 width
- Show Description or Not
- Show No of Visits or Not

Go to http://ankurthakur.in/ and see the Lower Center Panel.



-- View this Addon --
3854 views 0 votes
3 posts
Posted by Grimloch Last replied by Grimloch 3 months ago

Colorbox Problem

Fusion 7.02.07 colorbox problem under https protocol.

You know I really could use some help here. Until I made my site https, colorbox was working fine; no problems at all. I have done some research and can't find anything even remotely related to a problem with colorbox under https protocol.
210 views 0 votes
4 posts
Community Details
PHP-Fusion CMS Community
37.7k
Active Members
19
Online

The official English language support forum for PHP-Fusion CMS

Popular Contributors
  • Jackler
    Jackler
    3
  • ikandi
    ikandi
    3
  • marcolino
    marcolino
    2
  • RyanCombs
    RyanCombs
    2
  • symply clever
    symply clever
    1