Database and Locked Pages problem
Author: Robert Shroyer
Visited 6991,
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
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.
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?
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
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
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
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
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
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
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
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
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
To use these functions you need PHP on your web space
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
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:
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)
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.
HelloRobert,
unfortunatelythere isno attached, try to re-attach it.
contact your server and ask if the PHP 5 is correctly supported.
Let me know.
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
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"); ?>
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
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
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.
Author
OK thanks, I will check into this tonight and let you know. Thanks!
Bob
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.
another subdomain? Link?
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
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.
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
It would be nice to know how the problem was solved!
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