WebSite X5Help Center

 
Robert Shroyer
Robert Shroyer
User

Database and Locked Pages problem  en

Author: Robert Shroyer
Visited 6620, Followers 2, Shared 0  

I am having serious trouble with Pro. I had successfully installed the program and was working on my 2nd or 3rd site when all of a sudden the database link stopped working. None of the functions that use the database (Auto Registration, Guest Book and blog) are accessible anymore. I have verified all of the settings and still no go. How can I trouble shoot that issue? Everything works when I Review the site on my PC but not when I upload to server. I just get a blank screen. These are locked pages. If I unlock them I can use them. Strange Problem. Need some help fast. Thank Bob

Posted on the
29 ANSWERS
Incomedia
Riccardo P.
Incomedia

Hello Roberts,

verify that in the step 1 there is the correct URL for the site, try to disable the antivirus and the firewall and start the program as administrator.

Export the site and verify that it's work correctly.

Let me know.

Read more
Posted on the from Riccardo P.
Robert Shroyer
Robert Shroyer
User
Author

Thanks Riccardo. I did eveything you requested and it still doesnot work. I cannot do anything with the parts of the program that use the database (Auto Registration, GuestBook, Blog,). I cannot pull up the admin screen from the web. There is something wrong withion the program that is causing this. I have even tried replacing the database but still no good. Could it be something to do with the php files?

Read more
Posted on the from Robert Shroyer
Robert Shroyer
Robert Shroyer
User
Author

Riccardo just to clarify:

The /admin is inaccessible on the website url

http://nancysknitknacks.com/subwhse/admin

When I Lock a page in the website and upload the files, the page is blank when you visit the page on the web

When I lock a page, I can access that page when I go to PREVIEW but it no longer asks for username or password. But when I try to access that page on the web it is blank.

If I unlock the page and upload it, I can access it.

How can we refresh the entire set of code that has to do with the access/database area? Plus what role does the php naming play in all of this? I have a feeling there is a disconnect in the html to php coding that may be causing this. Could it be that those pages that were locked at one time but then the lock was removed, cannot convert back to html and somehow this represents a problem? In other works those pages were html to begin with and the program converted them to php. Is that not correct?

I even tried to attach a new database but that did not help. The database is not the problem, it is in my progam. I have other subdomain websites  under the same domain but these have no problems.

What would prevent the admin from running? So if I have a lock on a page the admin will not run, and if I have no lock on a page the admin will not run. But the website will run in Preview mode on my PC if there are locks or no locks and I am never asked for a password or username.

Originally this all worked well so obviously something happened 

In any event I have about 100 registrations in the database  and would like not to lose those or to have to redesign and enter all of my pages again.

Thanks for your help

Bob

Read more
Posted on the from Robert Shroyer
Paul M.
Paul M.
Moderator

Hello Bob,

You are running your site in a sub-folder of root, and this is what is causing you problems.

Your admin panel is currently located at:

http://www.nancysknitknacks.com/admin/login.php

If you wish to upload your site to the subfolder 'subwhse' then you will need to alter relevant fields in WebSite X5 accordingly, in particular the website URL in Step 1 as Riccardo pointed out.  This should be set to http://www.nancysknitknacks.com/subwhse/ in that case.

Best regards,

Paul

Read more
Posted on the from Paul M.
Robert Shroyer
Robert Shroyer
User
Author

Thanks Paul - my url is correct already. Should I have done it differently than that, for example should I have installed the website as follows:

www.wholesale.nancysknitknacks.com vs. www.nancysknitknacks.com/subwhse/ ?

Does it make a difference?

How can I get my existing site to run in a new website without having to re-create all 25 - 30 of my pages? Can I give you access to the server and have you check that to see if something else is incorrect there? Keep in mind everything was working well and then all of a sudden it went out of control relative to auto registration and database access.

What controls the admin panel?

Early on Claudio sent me a new x5 engine which I installed which fixed auto registration problems in your software. Were those changes also included in release xx.39? Is xx.39 a complete install or a patch?

Why would the sofwtare run OK (except for auto registration and locked pages) on my PC and not on the Internet?

My registartion has been down for days now and I have to get it back up. What can we do to geg this problem corrected? It is taking too long for it to be corrected. I can call Itally tomorrow  (I tried today but they said you have no phone support in Italy even though your website says we can call).

Thanks for your help

Bob

Read more
Posted on the from Robert Shroyer
Robert Shroyer
Robert Shroyer
User
Author

Paul, an additional note. X5 indicated I needed to have a folder which had full write priviliges (777) which I created and named "write" and mput on the root of the subdomain (/subwhse).

I notice that there are no folders installed there which on my other X5 websites X5 had installed blog, Guestbook, etc. Could this be the problem, that the Folder with write privileges is not working correctly and therefore the program has no where to write data to?

Bob

Read more
Posted on the from Robert Shroyer
Paul M.
Paul M.
Moderator

Hello Bob,

Please log in to your admin control panel at:

http://www.nancysknitknacks.com/admin/login.php

using your admin username and password, which you will find in Step 4 Access Management of WebSite X5.

Once logged in, please click the 'Test' link in the top-left hand corner of your screen.  This will invoke X5's built-in test facility.  Please let us know if you receive any error messages (and if so, what they are)  -  please also let us know the version of PHP running on your server...  this information will be provided by WebSite X5 in the same test screen.

Version 10.1.0.39 of Professional includes the fix for the registration bug in earlier releases  -  if you are running 10.1.0.39 then you are fine on that score.

Please note that I don't actually work for Incomedia, but I'm happy to help out if I can.  This will almost certainly be a server configuration issue.  When you first noticed the problem, what had you done just immediately prior to that?  Did you move the project from an initial location into the 'subwhse' sub-folder?

Kind regards,

Paul

Read more
Posted on the from Paul M.
Robert Shroyer
Robert Shroyer
User
Author

Thanks Paul

When I try to launch the admin nothing comes up at all. I have verified that the login file is in that directory on the server but nothing comes up. So I can n ot test the database and the connection. That seems to be the overall problem is that even thjough there is data and fiels there, I cannot launch/use them.

My PHP is 5

I cannot remmeber what I was doing at the time. Mostly I was adding cointent and designing content. I did experience some strange Injhternet access problems in which nmy Ciusco Netwrok Magic program said I was not coinnected to the Internet when I was. That was very odd and I neverr dertemiend what caused that problem with Network Magic. I ran Virus scans and Registry checks and nothing was amiss. While this was occurring I discovered this problem with X5.

I was using a VPN connection and of course you cannot connect to the server when using a VPN so I had to switch that off to get the data to go to the  server. I eventually uninstalled the VPN. So thertre may be csome conenction between the VPN, Network Magic, and X5 because all three were giving me a headache!

So now I am not using Network Magic nor the VPN and I can send data to the server but this feature in X5 that we have been discussing is not working nor can I access the files like login.php on the server.

I tried to access a new database which has no data on it and I cannot use that either so either the X5 code is messed up on my system or the link to the databse is messed up or.......

What do you think?

Thanks

Bob

Read more
Posted on the from Robert Shroyer
Paul M.
Paul M.
Moderator

Hello Bob,

When I visit http://www.nancysknitknacks.com/admin/login.php in my own browser I am presented with the login form for the WebSite X5 admin panel which proves it is in the wrong location on your server.  If you are intending to host your site with the 'subwhse' folder as root then the admin login should be at:

http://www.nancysknitknacks.com/subwhse/admin/login.php

Which again points to the Website URL setting in Step 1 being suspect...  do you have a forward slash after 'subwhse' ?

http://www.nancysknitknacks.com/subwhse/

Or do you have the URL without, as follows...

http://www.nancysknitknacks.com/subwhse

My advice at this stage would be to wipe all WebSite X5 files from your server, then hold down the 'CTRL' key whilst entering the preview mode in X5, then re-export your entire project back to the server, ensuring that both the WebSite URL in Step 1 and the Destination Folder in Step 5 are correct (Destination Folder should point to the 'subwhse' directory, unless your FTP settings are configured to reflect the 'subwhse' folder as root.

Your existing user registrations in the MySQL database should be safe, providing you are careful not to delete them when erasing the X5 files on the server.  But they should be well away from the public folders anyway of course.

Sorry to be the bearer of bad news, but until you can access the admin page in the location where it is supposed to be then it's almost certain that none of the PHP-dependent features will work in WebSite X5.

I think you're going to have to reupload the project, but do it cleanly like I suggest to avoid remnants of any old files remaining.

Best regards,

Paul

Read more
Posted on the from Paul M.
Robert Shroyer
Robert Shroyer
User
Author

Thanks Paul. By the way, I have several subdomains that were designed with X5 on the same site. SO I need to check but each X5 subdomian should be discretely separate from the others if they are loaded in folders, correct?

When I look at my server files, I see the Admin folder in the subwhse folder. Anyway, I will try the ideas that you recommended. It may be the problem. I will let you know but do explain if it is OK to have various X% installs in subdomain inside of folders under the same parent URL (www.nancysknitknacks.com) 

Thanks

Bob

Read more
Posted on the from Robert Shroyer
Robert Shroyer
Robert Shroyer
User
Author

Paul still no go after doing all of that. What permissions should be on the Admin folder and files?

I did delete the admin folder that was on the root and now it resides in /subwhse/ but can still not launch it. See if you can bring it up www.nancysknitknacks.com/subwhse/admin/login.php

Bob

Read more
Posted on the from Robert Shroyer
Der Zwoemti
Der Zwoemti
Moderator

To use these functions you need PHP on your web space

Read more
Posted on the from Der Zwoemti
Robert Shroyer
Robert Shroyer
User
Author

Thanks

After spending hours on the phone with 1and1 they then pointed me to a section on this site that reported a php problem and that X5 has a new php engine available? You can imagine my surprise.

Claudio - your were mentioned in the post. Is there a new php engine that roolves php problems? I have spent umpty ump hours trying to get this fixed and would appreciate the new file for x5engine.php

Please advise

Thanks

Bob

Read more
Posted on the from Robert Shroyer
Robert Shroyer
Robert Shroyer
User
Author

Paul - I did have an error in how I was accessing and uploading my files to my SUBDOMAIN. I have corrected that but I am still have problems using any of the admin php functions. I have now spent 6 days trying every permutation of using my website.

All of the html files work beautifully

None of the Php files work at all for me.

So I would like to know if ANYONE (moderators or customers) are actually using the following files in an active manner (not just as a one-time test) on X5-10 Pro:

  1. Automatic Registration
  2. Guestbook
  3. Locked Pages

I was able to get the Admin to run for a few minutes but then it failed.

Sinmce I cannot launch the login.php function I copy the address and manually loaded one of the admin files into the browser and I got this error (see attachment)

Read more
Posted on the from Robert Shroyer
Robert Shroyer
Robert Shroyer
User
Author

The error that I saw is on the attachment. This was not returned when launching one of the admin php files, I simply copied the address into the browser and it came up.

In a nutshell, I have tried literally everything to get the php files to run but nothing seems to work. The php pages come up blank.

For example if I have a locked page that should trigger Automatic Registration it doesn't come up (neither the page nor the Auto Registration page). If I then remove the Lock, then the page comes up. The Guestbook does not come up at all.

These did work for a brief moment and then they stopped. Something in the Website X5 code is causing the php files to fail I am convinced. 

I have no idea if anyone out is using these features but would like to know if they are.

Could the fact that I am using these within a subdomain be what is causing these problems? I love this sofwtare and really want to use it with the PHP functions. I have other X5 websites that work fine (all HTML) but using these X5-10 pro functions has been a problem for me.

Note: I was one of the first customers to see the locked registration problem and I may be the first to see this php problem! It is a real problem.

Read more
Posted on the from Robert Shroyer
Incomedia
Riccardo P.
Incomedia

HelloRobert,

unfortunatelythere isno attached, try to re-attach it.

contact your server and ask if the PHP 5 is correctly supported.

Let me know.

Read more
Posted on the from Riccardo P.
Robert Shroyer
Robert Shroyer
User
Author

Please send me your email address. This system will not allow pictures to be sent it just sits there and churns. It has been a real problem for the past week.

My email is ***

I can then send you images of this problem

Bob

Read more
Posted on the from Robert Shroyer
Der Zwoemti
Der Zwoemti
Moderator

If Iam not mistakenyou have
PHP/5.4.21
activated.

Butotherphppages workcorrectly?
https://www.nancysknitknacks.com/BobsBlog/bobsblog.php

The erroronly occursonpageswherephpcodeis at the beginningorrequirethe firstis?

the side
http://www.whse.nancysknitknacks.com/new-shop-special-save-10-.php
and
http://www.nancysknitknacks.com/subwhse/new-shop-special-save-10-.php
work.

Thusmy guess isactually clear-
<?phprequire_once("res/x5engine.php");?>
can not be performedbecausethe path isunlikely to be found.

You canhere by handinone of yourphpfilesthatchangedoes not workthe firsttimephpcalland letyouspenderror.

<?php error_reporting(E_ALL | E_STRICT);
ini_set("display_errors", 1);
echo "Until here everything goes";
require_once("res/x5engine.php"); ?>

Read more
Posted on the from Der Zwoemti
Der Zwoemti
Der Zwoemti
Moderator

The resultof yourtest shouldlook like this.

Until here everything goes Warning: require_once(res/x5engine.php): failed to open stream: No such file or directory in /www/......./......../yoursite.php on line 4 Fatal error: require_once(): Failed opening required '.res/x5engine.php' (include_path='.:/usr/share/php') in /www/......../........./yoursite.php on line 4

Read more
Posted on the from Der Zwoemti
Robert Shroyer
Robert Shroyer
User
Author

Hello Der Zwoemti

I have a domain: www.nancyknitknacks.com

On that domain I do have a 3rd party blog (not X5)

That blog works fine there is no issue with the domain files

I also have 2 subdomains under the domain. These are for a product line (ballwinders) and for Wholesale customers (whse). This subdomain is where I use the php files for blog (X5 type) and Auto registration, etc. It ois this subdomain where I have all of my prpoblems, The other subdomain (Ballwinders) does not use any php features and has no problems.

The problems come in whe I add the lock to a page to trigger Auto Registration

The pages which had confidential whse pricing I had previously added LOCKS to in order to prevent retail customers from seeing these pages. But since the pages don't work with a lock(they come up blank), I removed the locks until such time that we cn fix the problem. The pages under Shopping which refer to View Price list lock or no lock relate to the ones I asked Claudio to check into.

I am sorry but I do not understand the point that you are raising about the  run once issue. Is there something that I have done wrong in setup?

Thanks

Bob

Read more
Posted on the from Robert Shroyer
Der Zwoemti
Der Zwoemti
Moderator

Your problem ismost likelyreally just aserverproblem.
UnfortunatelyI do not speakreallygood EnglishsoI translatethe text withgoogle.I'mGermanbut'll tryto help.

Thepiece of codeyou writehere by handwith an editorinto thephpfile.
You can also justtaketheimsearch.php.This file isfirstcreatedandhasnothing to dowith the other.Butthisuses the"requireonce"indicationalso.

The saidcodeis importantfor error analysis.Forthe momentyou havean erroron the side ofto do with thePHPversion.With youbutthe error outputis switched offand thusyou do not seethe error.

When youturn onthe codean output is generatedas described above.Asyou can seewhich pathisactuallycalled.

I canexplainitbadlyunfortunately.

Simply stated:

The PHPpagetriesto find a file.Butthisitisnotbecause the pathdoes not fit.

Read more
Posted on the from Der Zwoemti
Robert Shroyer
Robert Shroyer
User
Author

OK thanks, I will check into this tonight and let you know. Thanks!

Bob

Read more
Posted on the from Robert Shroyer
Robert Shroyer
Robert Shroyer
User
Author

Der Zwoemti - I revised the imsearch.php file as you advised and it did nothing new. I did not see any error codes. The same problems occurred. Pages with locks on them were not displayed and pages without locks were displayed.

Which specific file deals with the Locking attribute? What ever is messing up my application, it has to be some code that got into the setup some how.

I have another subdomain on this domain and it works fine with or without locks.

If I could just reset the code that is affecting the locking and auto registration codes then maybe, we could get this resolved. Is this possible?

I have tried reinstalling Professional numerous times but when I import this website the problem does not go away.

Read more
Posted on the from Robert Shroyer
Der Zwoemti
Der Zwoemti
Moderator

another subdomain? Link? 

Read more
Posted on the from Der Zwoemti
Robert Shroyer
Robert Shroyer
User
Author

Guys - I have a domain named www.nancysknitknacks.com

Within that I have 2 (and plan to have more subdomains) that focus on specific products or customer areas.

These are set up on the server as SUBDOMAINS

When I install or create the subdomain in Website X5 they are done as follows:

Domain: www.nancysknitknacks.com

Subdomain: www.ballwinders.nancysknitknacks.com

The data for this subdomainis stored in a folder named: subballwinder

Subdomain: www.whse.nancysknitknacks.com

The data for this subdomain is stored in a folder named : subwhse

The subdomain named ballwinders works great. I do not use any special X5 php features but when I tested it the other day they worked great

So the million dollar question is why would the whse subdomain not work properly relative to the admin, blog, auto registration, Guestbook features? Once I lock a page it is not accessible. Could it be that X5 stored some file location somewhere and never updated those locations?

I believe in the beginning I may have duplicated the website and then started using it. COULD THAT have permanently "set" the file locations for the prior website? If so how do we check for that and how do we correct it?

Or, is the subdomain structure that I have created causing the problem with the PHP files only? HTML is fine.

Can't someone at Incomedia answer these questions and help me resolve this problem once and for all?

I can provide someone with access to my server and am willing to pay for the support.

Thanks

Bob

Bob

Read more
Posted on the from Robert Shroyer
Der Zwoemti
Der Zwoemti
Moderator

Someonein the Italianregionalsoproblemswith 1 & 1seems to have.
http://answers.websitex5.com/post/77739


The easiest wayto find out ifPHP is runningcorrectlyonweb spaceof the folder /Sudomainis thephpinfo

To do this youerstelltstat times thefile.

https://kb.mediatemple.net/questions/764/How+can+I+create+a+phpinfo.php+page%3F#gs

Ifyouno textwillappearwhen you runthe file in thebrowserunder thesubdomainsorfaultythenyourphpfunctionsfor thissubdomainfolder is notcorrect.

Read more
Posted on the from Der Zwoemti
Robert Shroyer
Robert Shroyer
User
Author

Thanks Der Zwoemti

I ran phpinfo and it listed multiple pages . I did not know what to look for but I saw no error messages, just configuration data. I am running 5.4.1 PHP

I did provide Claudio with info and access to the site today so hopefully he can investigate the problem.

Thanks for your assistance

Bob

Read more
Posted on the from Robert Shroyer
Der Zwoemti
Der Zwoemti
Moderator

It would be nice to know how the problem was solved!

Read more
Posted on the from Der Zwoemti
Robert Shroyer
Robert Shroyer
User
Author

Thanks. OK, it turned out that 2 of my whse customers registered thru the Auto Registration system and they used a "\" and a " ' " in their username. That is what caused the system the lock up!

Claudio discovered it and he solved the problem. I deleleted those two entries and now I have added instructions in the Registration text for the user to not use either a ' or a \ when creating a username. I would have thought they wouldn't use those 2 characters but they did and that is what caused the problem.

Once we deleted those 2 registrations, the problem disappeared!

Thanks for your help. I am a happy user once again.

Bob

Read more
Posted on the from Robert Shroyer