Have you checked the /admin > Website Test page? Assuming all looks good there, please tell us which php version is on your server?

I also would verify the email configuration in Step 5, and check your that your DB hasn’t reached its limit (as with some hosting).

Andy, Thanks for your response.  The site is using PHP 8.0 and the DB size is well within limits.

I have asked my client [who manages Updates, sales, despatch and stock to check the /admin>Website test page.  He has his own X5 Pro  and all emails and ecerything was working on until the last November update. He has had hundreds of sales and emails all going well. Its only the X5 update that we figure had caused the error

Good morning, Peter.

I learnt very recently that php7.4 reached its EOL in November. So, I felt it necessary to check that this wasn’t your issue. But since you’re using php8.0 and WX5 2022.3, then this should be fine.

It is also good to know that your database is healthy.

I setup a (very small) fake shop on my test site the other day, to test WX5 2022.3 with the new php8.2. My test orders were sent to the DB and I received the notification emails without any problems.

I can only assume that something else is going on here.

Could you go to the /admin > Website Test page, and use the email test form at the bottom to confirm that you are able to send emails without problems?

I might also suggest that you manually download the latest WX5 version from your Profile/Account > Download page, and reinstall the app. After installation is complete, I recommend rebooting the device before opening WX5.

That’s all I have I’m afraid.

Please report your steps and the result here so that more experienced users/staff can see.

Good luck Peter!

Have tested via Website X5 Management..

and the result is in the image attached..

Really hurting on this as unable to process orders effectively.. Appreciate the help

I see that the full ‘PHP Mailer’ script is selected. Are you able to switch to ‘PHP Mailer (SMTP)’ and repeat the test?

If the test fails using ‘PHP Mailer (SMTP)’ then I recommend trying another email provider for the test.

I believe that the Website Test form requires all fields to be completed.

Andy.

Peter, I am sure that bigger brains are looking at this. If the problem is confirmed or identified, you will hear from them, rest assured.

I sincerely hope that the issue is resolved for you sooner rather than later.

All the best!

Thanks, will try that.. That Prince of yours is creating a bit of a stir!

I was assuming that ‘Prince’ was a typo, and spent some time trying to figure out what you meant lol. The penny has dropped, and I understand now.

I personally do not follow the royals... Money for old rope! Scratch the surface and you will find the problems run much deeper with them lot :o\

Did some futher research on the server connection and have found the error log file for this site is huge. Actually log file is 2.8GB. The server admin has sent me this from recent activity..

[30-Dec-2022 00:35:56 UTC] PHP Warning:  Undefined array key "auto_increment" in /home/woodhigh/marcoim                                                    ports.co.nz/res/x5engine.php on line 6058

See attachement 

Hello Peter

Can you try and ask the hosting to disable the PHP parameter called "display_errors"?

If they do this for you, does the error still appear after?

I remain available here

Stefano

Thanks Stefano..

Please look at pic..  I did not need to change anything..

It was like this pic already

You can activate the PHP error message via the php.ini file, although it is normally switched off.

Do you perhaps have such a php.ini file on your web space?

Hi William, its somewhat encouraging to see we are not alone with the very serious problem which is affecting my client business with lack of sales..

I was hoping Stefano would get more involved with his fantastic understanding and expertise.

I have just asked my client to reload his website using the X5Pro version I downloaded on 22 October 2022 version as that predates the problem and will see if that starts working OK.. He did not notice any error problems until 13 December and after taking the "update is available" option.

Will advise the result of that asap.

Has neither of you tried switching to php8.1, just to see?

I’m curious how many products/items you guys have configured in the shop(s).

Hi Andy, we do not have PHP8.1 available to us yet..  Currently on PHP8.0

I am not at clients Office so cannot say for sure number of products online but I figure its around 1800

Actually, I think I concur… I just installed php8.0 and configured my test site to use it. My shop won’t load at all now. And, I do not get "GENERIC ERROR" box.

Php8.1 and 8.2 do work for me o_0 Sorry.

Poking around, I found that my test site is generally a mess now, with php8.0. I can’t send messages, and a DB connection issue is being reported on my /admin.

I maybe overlooking something in my configuration. Investigating…

Ok Andy, thanks..  Actually the number of products is 3518 ans NOT the 1800 I guessed..  How big is yours.

I will go back to server host team and press for a later PHP..  Appreciate the comments Andy and William.

I am still uncertain why I am having issues with php8.0. I have checked my php8.0 conf/ini files, and don’t see the cause there. I’ll keep looking.

I only have 2 items in my test store. I only ask in case the number is somehow significant, Peter.

If it possible to switch to php8.1, I’d suggest that you both do this. Please report your findings here?

Thank you.

We have enabled PHP8.1 but on reloading the site to the server now we get the message "MYSQL database settings failed"   See pic attached..

So somehoe this loses connection to DB Server

Any ideas please

That’s interesting, Peter. Basically, you get the same SQL error moving php up, as I do moving php down.

I’m going to try exporting/importing my test site, to see if it makes any difference. And, anything else I can think of that might help overcome this. If I make any progress, I’ll report it here.

I tried exporting/importing my test project, but it made no difference.

I’ve also tried editing the DB host setting (Step 5) from ‘localhost’ to ‘127.0.0.1’ and also ‘[URL]’. All to no affect.

However, if I switch php back to 8.1 or 8.2, everything works as expected.

I’m a little dumbfounded. But if I think of anything else to try, I come back with it.

Also, I now believe that before November, you were using php.7.4, Peter. And that your issues started when your host moved to php8.0.

Because php7.4 has been shelved now, you probably won’t be able to switch back to it. Therefore, my theory (and temporary workaround) cannot be tested.

Staff will be back in tomorrow. I look forward to reading their response.

I just thought… Peter, if you (or your client) have an old iwzip backup that can be used with WX5 2022.2, then you might have success downloading/installing this version from your Account/Profile > Download page.

I beleive that this will only work if your iwzip backup was created using <WX5 2022.2. But it might serve as a temporary workaround.

Thanks Andy.  Will discuss with my client.  Hopefully Incomedia team get involved.

Just for the record here is my PHP ini file pic

Hi Jim,

I am encouraged that I am not alone in the boat.

Thanks for the advice however your referred to post is set as private.

Hi Peter S,

Oops, sorry I forgot that Stefano G had set the post to private. I have removed the "private" information.

Below is a transcript of the main posts.

Jim.

Hi,

I am using Evo version 2021.5.7, I have not updated to later versions as unfortunately Incomedia updates tend to be one step forward in some areas and three steps back in other areas.

I had a website Poll page which I have deleted along with the data base on the hosting server, when I upload the website to the server I get the following pop up:

If I click on ignore the upload completes OK, however I would like to remove this annoying warning.

Any help would be appreciated,

Thank you,

Jim.

Hi,

Update, following some checks I had used the Poll object to conduct a survey in my initial version of my project. On checking in my current project files, I have found 77 references to the survey I created in my original project these pages had already been removed ages ago. I have now deleted the files from the current version. In the Objects Used in the project, my initial project showed that the Poll object was used in the project.

After I had deleted the survey pages from my initial project, the current version does not show the Poll object as being used in the project. I therefore do not know why I am still getting this warning message.

Any help to resolve this issue and remove the warning message would be appreciated.

Jim

Maybe ask the web host provider for the MySQL settings, the MySQL settings probably no longer match the current version of WebSite X5.

Good Afternoon Daniel W,

Thank you for your feedback, my project www.**** no longer contains or uses any data base files. I have completely deleted my project from the hosting server and reinstalled it with no known data base files or requirement.

My question is therefore why I am getting this warning:

So, looking for the reason why this warning happens and how to remove it.

Your help is appreciated.

Jim.

It may help if the database information is deleted, since they are not needed anyway.

The WebSite X5 program checks whether the web server meets the requirements for PHP and MySQL.

If deleting the database information does not help, then the web hosting provider should check whether the MySQL version is up to date.

The moderators may be able to provide additional information about WebSite X5 in order to eliminate the error message.

f the database information in the Database section of the parameters is not to be changed, Incomedia must delete the information about the database. To do this, the project should be made available as an iwzip file, for example at wetransfer.com. The link for downloading the project should be submitted in a private post.

Hi Daniel W.

Thank you for your further feedback.

I had already deleted the data base on the hosting server as the data was no longer needed, however the MySQL database settings warning still popped up.

Hi Franz-Josef H.

Thank you for your feedback, I have carried out some further testing:

1. I created a “new” survey page using the Poll Object and a “new” Data base on the hosting server, using the same credentials as in my previous version.
2. When uploading the project to the server I still get the MySQL Database settings warning pop up. However, when I click on Ignore the upload completes as expected (the same as before).
   
   

The PHP version on the host server was PHP 7.2, I have updated this to PHP 8.0 but this has not made any difference.
The MariaDB version on the host server is 10.1.48 and the Protocol Version is 10. There does not appear to be any option to change this version to anything else.

Given that the data base appears to operate correctly, Website X5 would appear to be producing an erroneous warning pop up.

Your views on this and any other help that you can provide is appreciated.

Jim.

Hello Jim

I've turned the topic private

Please go to Step 5 and export the project locally as IWZIP. Then, send it over to me here and I will verify it personally for you

You can use the service https://wetransfer.com/ Select the link generation and paste it here, so I can download the file. If the file is too big, please don't include the folders preview and backup files when you create your IWZIP file with WebSite X5.

I remain available here

Stefano

Hello Jim 

On the page named Survey Poll, I can see that a Database is configured:

Can you please remove this and other similar Objects and try again?

Thank you

Stefano

Hi Stefano G.

Thank you for the feedback, I have removed the survey poll as requested. I have also checked what objects are used in the project see below:

As you can see there are no Poll objects used, however when I try to upload the project I get the warning message (same as before), on clicking ignore the project uploads as expected.

Any further help or advice is appreciated.

Jim.

Thanks for the info, Jim.

I have just tried removing all backups from the master save file--No affect.

Then I tried creating a new DB schema--No affect.

So, I created a new project. I removed all files from the host, and have tried both of my test schemas--No affect. SQL error persists.

The ONLY thing that works for me is configuring nginx with php8.1 (or php8.2).

The fact that this issue doesn’t seem to be isolated any single php version makes it complicated. And I have no clue where the residual information is coming from.

It is possible that completely removing WX5 (including \Appdata\WX5) from the OS will resolve the issue. But I will wait to see what the staff say.

I couldn’t help myself... I just removed WX5 and C:\Users\[MyUser]\local\AppData\Incomedia. Then I clean-installed WX5–No Affect. The issue remains.

I was convinced that this would resolve the problem. I stand corrected.

@Andy W.:It is best to open a new thread and describe the problem again so that the forum users can concentrate on this problem.

@Daniel W.  I am only attempting to replicate the issue posted by Peter (and others) and attempting to work-around. I am reporting my steps as completely as possible to inspire and inform. I do not believe that another thread will be useful to anyone, do you?

@Daniel W.  You might offer some usefulness if 1) you can replicate this issue and/or 2) offer any meaningful input to work-around or resolve the problem. I do not consider repeating staff and laying down unwritten laws as useful, mate.

In a recent German post, the PHP setting was...

display error = on

... to blame for massive problems, maybe there is a "needle in a haystack" here too.

In a recent German post, see

----- Translated with Google -----

Kai A.: (The first post)

since the update the search page of the shop doesn't work anymore.....

I am using Website X5 Pro Vers. 2022.3.6

The PHP version at One.Com is 8.1

Had such a problem before.....it was because of the PHP version....

The last post of 51 posts

it's working again, apparently it was just the PHP error messages. If these are switched off, everything runs as before.

>> https://helpcenter.websitex5.com/it/post/255955

-----------------------------------

It's probably a wrong setting somewhere.

This possibility was explored earlier in this thread. And, I believe it is safe to say that none of us here has php configuration ‘display error = true’.

Its looking like a problem in the code, Daniel.

The one thing I cannot test is using WX5 2022.2 with an appropriate iwzip. This is because I accidently formatted the MMC that used to house my WX5 backups.

Another German thread (translates with Google).

-----

First post:

Website is not displayed correctly

I've been trying to get my website up and running for days.

Last post of 22 posts:

I found the mistake. The parameters for uploading were adjusted, although I didn't do anything about it.

-----

In most cases, it's just very small mistakes that cause you big problems.

So you have to systematically check all the settings, both on WebSite X5 and on the web server, and don't take anything for granted.

Peter has posted images of his php.ini configs via cPannel. Please, knock yourself out mate.

I have triple-checked my php.ini, and I know it’s as it should be. But, if I switch back to my original php version, everything works again (no SQL error).

It looks like the php version isn’t significant, but changing php IS. You should be able to easily test/replicate this (as I did).

I don't have an online shop and I won't set one up specifically for testing.

But if 2 users work on solving the problem, then hopefully one of them will find the solution.

I'm curious what the "needle in the haystack" means in this case.

So - now I let the two heroes continue to work.

I’ve seen no heroes here yet, Daniel. Just people losing money.

Please do come back if you think of anything useful/original.

Cheers buddy!

When I click "Seach" on the www.marcoimports.co.nz website, only the loading icon spins.

The same in the German thread, where this rotating loading symbol is also attached as an image in the first post. Is that a coincidence or is it the same reason behind it?

Are you sure that "Display Error" is also set to "off"?

I checked this as well as soon as I saw your post Daniel. I live in New Zealand, so thought I would see if the site is locally hosted  then that might make a difference. I get the same spinning loading symbol and can't click on any of the search parameter boxes.

Hello Peter

I've turned the topic private to be able to properly help you with this issue carefully. I'm currently downloading the project and I will then proceed to some testing.

As soon as news on this becomes available, I will notify you here

Thank you for your patience

Stefano

Hello Peter

I've checked your website and I found this error generated by the project:

This really means that the hosting messed something up and the website no longer has access to the Database.

You can show the piece of code I attach here to them. This shows them how the software connects to the Database:

They can use this to check why the connection is no longer working. Let me know what they say

I remain available here

Stefano

Thanks Stefano. I have passed this onto my host..  But it begs the question? This site had been active for over a year now and it seems it did not start the error until we did the November update.

Will advise when I hear back from the host..

Hi Stefano, Some progress..  Here is comment from host server admin/support

"on server we have all php versions from 5 to 8.1 and you can choose whichever you want for your domain form multi php manager.  I can see for this domain, you are using 8.1.

Our system admin installed MySQL extensions (mysqlnd & PDO), please try now and if you still have problems, let us know how to reproduce the problem and our system admin checks again."

Ok on trying it, its now connected to DB so now we can search, see, and buy a product and it generates and sends the email advising the purchase, but it then comes up with GENERIC EROR, the item STAYS in the shopping cart and the item stays in stock and the stock is NOT reduced..  So progress but now seems its back with you please..

Look forward to your urgent advice..

Hello Peter

It's great to hear that the resolution finally encountered some progress.

Now, about this error, when I make the purchase the real error being the Generic Error is this Error 500:

Please send this screenshot to the hosting provider and tell them that they can see this too by performing a test order. 

In order to solve this, they must investigate their server's Error Log where the real error is displayed. Error 500 is just a generic name for the real error, which can only be seen on the server to which we have no access

Get this information from them and let me know that here

Thank you

Stefano

Thanks Stefano..  Saw you order test go through system..

Have passed your comments exactly to Host server team

Will advise asap

The srver guys advise..

I can see the following error in /home/woodhigh/logs/marcoimports_co_nz.php.error.log.  You do not need to server logs. All php errors are logged here.

It looks like X5 is using curl function,  I will check with our system admin whether this is available and get back to you.

Team @ NetNeeds

[14-Jan-2023 07:01:06 UTC] PHP Warning:  Undefined array key "order" in /home/woodhigh/marcoimports.co.nz/res/x5engine.php on line 2520
[14-Jan-2023 07:01:06 UTC] PHP Warning:  Undefined array key "settings" in /home/woodhigh/marcoimports.co.nz/res/x5engine.php on line 2521
[14-Jan-2023 07:01:07 UTC] PHP Warning:  Undefined array key "order" in /home/woodhigh/marcoimports.co.nz/res/x5engine.php on line 2520
[14-Jan-2023 07:01:07 UTC] PHP Warning:  Undefined array key "settings" in /home/woodhigh/marcoimports.co.nz/res/x5engine.php on line 2521

[14-Jan-2023 07:01:07 UTC] PHP Warning:  Undefined array key "html" in /home/woodhigh/marcoimports.co.nz/res/emailtemplates/order.html.template.php on line 245
[14-Jan-2023 07:01:07 UTC] PHP Fatal error:  Uncaught Error: Call to undefined function curl_init() in /home/woodhigh/marcoimports.co.nz/res/x5engine.php:7740

Stack trace:
#0 /home/woodhigh/marcoimports.co.nz/res/x5engine.php(4927): Notifier->sendNotification('ECOMMERCE_ORDER', '{ "orderNumber"...')
#1 /home/woodhigh/marcoimports.co.nz/res/x5engine.php(1955): ImCart->sendOrder(Array, Object(Notifier))
#2 /home/woodhigh/marcoimports.co.nz/res/x5engine.php(1849): CartRouter::{closure}(Array)
#3 /home/woodhigh/marcoimports.co.nz/res/x5engine.php(2052): Router->handleRoute(Array)
#4 /home/woodhigh/marcoimports.co.nz/cart/x5cart.php(1502971): CartRouter::handleRoute(Array)
#5 {main}
  thrown in /home/woodhigh/marcoimports.co.nz/res/x5engine.php on line 7740
[14-Jan-2023 07:02:03 UTC] PHP Warning:  Undefined array key "auto_increment" in /home/woodhigh/marcoimports.co.nz/res/x5engine.php on line 6058
[14-Jan-2023 07:02:03 UTC] PHP Warning:  Undefined array key "auto_increment" in /home/woodhigh/marcoimports.co.nz/res/x5engine.php on line 6058

On 2023-01-14 11:20, Peter Sinke wrote:

Yes, progress but error still and Website X5 staff still say ...

It's great to hear that the resolution finally encountered some progress.

Now, about this error, when I make the purchase the real error being the Generic Error is this Error 500:

Looks like its fixed.. did not try via Credit card yet but the BANK Transfer option appears to work..

Will get my client to try all option paths tomorrow..  Thanks for your help..  Are the Host guys saying that X5 should acyually identify the error rather than a generic error??

Hello Peter

I'm not sure. The error either generic or not is detailed by the hosting, not by the software.

What I can understand is they saying that the software could technically test that every requirement is present on the server, and that is true.

Unfortunately, at the moment this is not done so it is still necessary in situations such as this, to request the support of the hosting

Glad to hear it seems to be working now!

Stefano

Ok Thanks Stefano. I am still a bit confused.. Would appreciate a summary of what caused problem..

Did the X5Pro update cause the host server provider to have to install NEW extensions and new .exe updates that they did not know they had to?  And if this is so maybe X5 should have advised that at the time of update?

Appreciate your comments and it is so good to have sales again..  Pete

Hello Peter

I would say that they either disabled it, or something else happened.

CURL was always used by previous versions too, and is also usually enabled by default on all hosting. It is very rare to find an hosting which has it disabled and for this reason, CURL is a cause is rarely investigated

I remain available here

Stefano

Ok Stefano, thank you.

Perhaps you could summarize wahts happen so its not private so the Website X5 community can see PUBLICALLY the solition/reason for our difficulty. Many of them offered suggestions but now do not know the progress, success or soution..

Actually if CURL was there before and our earlier version worked ok how come the X5 upgrade seemed to provoke problems.

Appreciate the expert guidance

Hello Peter

That would be perfectly fine. Let me know if you wish the topic to be turned public again, and I will do so after hiding posts which might contain sensitive data such as the link to the project

I remain available here

Stefano

Hello Peter

As per request, the topic is now public again

It is important to remind that the PHP curl functionality must be enabled on the target hosting since it is used by some specific parts of the website to complete internal procedures.

These may fail if curl is disabled, but in most cases, it is always on by default. Failure to have this feature enabled can comprise the correct functionality of the E-commerce and potentially, other advanced functionalities too

I remain available here

Stefano