Help Please Ladies and Gents ... I think I broke it !!!!

So if understand correctly, live site is in a directory, this new upgraded site is in a subdirectory off of your live site. I don't remember who mde the recommendation on the first page of this thred, but the thought was to have your live site now point to this new directory. The alternative would be to transfer all of the files (except the includes/configure.php and admin/includes/configure.php) over to the drectory referenced by your uri after removing the existing files, which could be better done by folder renaming from the host's cPanel...

Right now, your site as accessed by the "public" is yes the old version and no should not be put live if the above is true. Now, if they installed updated files in the same place as always, the indications of your previous message indicate that the files are "all" up-to-date... So further answer depends on providing the clarity of what the current situation/state of "sites" off of your uri.

Ok ... as I can understand what has happened in my naivety .. is that no core zc install has been done from 1.3.8a (eg to 1.5.4) ... but utilising the database upgrade feature from zc install .. it has updated the database only.

All the directory structures have not changed for the url .. nor is there any sub directory installs of any other version of zc .. but it seems as though certain directories have been added in the migration .. such as YOUR_ADMIN_FOLDER which even I know would never work as it has not been renamed to the actual admin folder. What the hosting Company have done .. I have no idea .. but for sure .. someone has been messing around in there.

So, one of the (many? :) ) questions asked was in the upper right hand corner of the admin screen, does it say you are currently using ZC 1.5.4 or 1.3.8 or nothing at all? (Typically just below the check for upgrade button).

This is now what I see in version info tab and there has been no zc install run for setup of 1.5.4 on the server ....

Zen Cart 1.5.4

Database Patch Level: 1.5.4

v1.5.4 [2015-07-13 21:28:38] (Version Update 1.5.3->1.5.4)
v1.5.4 [2015-07-13 21:27:55] (Version Update 1.5.3->1.5.4)
v1.5.3 [2015-07-13 21:27:55] (Version Update 1.5.2->1.5.3)
v1.5.2 [2015-07-13 21:27:55] (Version Update 1.5.1->1.5.2)
v1.5.1 [2015-07-13 21:27:55] (Version Update 1.5.0->1.5.1)
v1.5.0 [2015-07-13 21:27:55] (Version Update 1.3.9->1.5.0)
v1.3.9h [2015-07-13 21:27:55] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2010-04-30 16:38:16] (Fresh Installation)

Also .. in the top right it says database is up to date version 1.5.4

wallart studios:

This is now what I see in version info tab and there has been no zc install run for setup of 1.5.4 on the server ....

Zen Cart 1.5.4

Database Patch Level: 1.5.4

v1.5.4 [2015-07-13 21:28:38] (Version Update 1.5.3->1.5.4)
v1.5.4 [2015-07-13 21:27:55] (Version Update 1.5.3->1.5.4)
v1.5.3 [2015-07-13 21:27:55] (Version Update 1.5.2->1.5.3)
v1.5.2 [2015-07-13 21:27:55] (Version Update 1.5.1->1.5.2)
v1.5.1 [2015-07-13 21:27:55] (Version Update 1.5.0->1.5.1)
v1.5.0 [2015-07-13 21:27:55] (Version Update 1.3.9->1.5.0)
v1.3.9h [2015-07-13 21:27:55] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2010-04-30 16:38:16] (Fresh Installation)

Welp, somebody ran it yesterday around 21:27 local server time... Considering that all other things have been modified (including the magic new directory) it would seem that your host did this upgrade for you or a phantom coder that decided to "help you out" of which I would hope none but yourself (and your host) could gain the access necessary to do that without your knowledge...

If though, truly do not know who did it, I would suggest running through the potential hacked actions... (Of course could give your host a call to ask about what happened... :) )

Only other "thing" I am thinking about is that if the shipping and payment modules were deactivated and reactivated forcing the updated code to repopulate the database for operation under the current version, and that any shipping/payment plugins (or any other for that matter) are up-to-date. For example, UPS, USPS, FedEx, and many others have required updating to work with their servers and to collect the necessary information.

Also there may be some issues with the template files as compared to the template_default equivalent if they do not handle/process data the same as the template_default version... But, it looks like yes you could use a 1.5.x version template on your site...

It would also still be suggested to investigate any differences in your core files as compared to a vanilla ZC install if in fact it was all installed by the host as there may be significant differences in security or functionality. (Won't know until the comparisons are performed and verified equivalent with only known/desirable modifications/differences.)

No panic mc12345678 lol .. the upgrade was ran by myself last night just before I posted that it blocked admin (my timing was 21.27 UK time) :D

Template wise .. all seems to be running the same as it was before and functioning ... only thing I have noticed is that image handler does not show larger images in the box .. but hover over still works (this is to be expected as the image handler is V2 and to my knowledge .. Image Handler 3 is required for zc 1.5)

All shipping modules and payment modules are as they were originally .. api callbacks .. the lot. I have checked those out as they are imperative to sales and shipping methods available :)

Once again .. to all those that have tried to assist and I must say ... outstanding input and recommendations here which seems to have cured my issues and saved my Business ... I owe you all a hearty drink should we ever meet in person :cool:

wallart studios:

No panic mc12345678 lol .. the upgrade was ran by myself last night just before I posted that it blocked admin (my timing was 21.27 UK time) :D

Template wise .. all seems to be running the same as it was before and functioning ... only thing I have noticed is that image handler does not show larger images in the box .. but hover over still works (this is to be expected as the image handler is V2 and to my knowledge .. Image Handler 3 is required for zc 1.5)

All shipping modules and payment modules are as they were originally .. api callbacks .. the lot. I have checked those out as they are imperative to sales and shipping methods available :)

Once again .. to all those that have tried to assist and I must say ... outstanding input and recommendations here which seems to have cured my issues and saved my Business ... I owe you all a hearty drink should we ever meet in person :cool:

IH4 is the route to go these days, and I think there is still some work being done to it on github for ZC 1.5.4... But, YEAH!!!

Well ... so much for the fix :(

I had notifications that new customers couldnt register. I then realised that Fast and Easy Checkout module was installed so ran the sql patch to remove it.

Now when I try to access admin .. I'm getting the error message of "1060 Duplicate column name 'configuration_tab'
in:
[ALTER TABLE configuration ADD COLUMN configuration_tab varchar(32) NOT NULL DEFAULT 'General';] "

Obviously this is a database issue again. Any idea how I go about editing the database ? .. I would assume from the 1060 ... that would be the line that is playing up ?

Good news is .. checkout is working ... bad news is .. I'm locked from admin again GRRRRRR

wallart studios:

Well ... so much for the fix :(

I had notifications that new customers couldnt register. I then realised that Fast and Easy Checkout module was installed so ran the sql patch to remove it.

Now when I try to access admin .. I'm getting the error message of "1060 Duplicate column name 'configuration_tab'
in:
[ALTER TABLE configuration ADD COLUMN configuration_tab varchar(32) NOT NULL DEFAULT 'General';] "

Obviously this is a database issue again. Any idea how I go about editing the database ? .. I would assume from the 1060 ... that would be the line that is playing up ?

Good news is .. checkout is working ... bad news is .. I'm locked from admin again GRRRRRR

uninstall SQL does not remove files... If FEC was still installed, then the files also need to be removed which I think is what is trying to "alter" the table and finding that it can not because well, also seems that the uninstall probably didn't unalter it... Or if it did, then other code that remained is just repeating to attempt to do steps that were successfully undone but redone...

Sorry, starting to dive in... Need to remove the files that were added and restore the files that were modified/removed by adding FEC. Or should have been able to disable it.

I have removed every file associated with FEC and the same error still there. Many thanks for your reply and attention again mc12345678 .. but still no admin.

I cant get into the admin to possibly re run the sql patch for uninstall just in case it didn't remove it properly ... so I am still stumped what to do here

wallart studios:

I cant get into the admin to possibly re run the sql patch for uninstall just in case it didn't remove it properly ...

Even if you could, it wouldn't help in any way.

It doesn't matter if the database DOES contain remnants of the installation because they will never cause any problems.

Whatever the cause of your problem, it ISN'T a database issue.

wallart studios:

I have removed every file associated with FEC and the same error still there. Many thanks for your reply and attention again mc12345678 .. but still no admin.

Correction. If you really have removed every file associated with FEC then you wouldn't be getting this problem, unless the problem has nothing to do with FEC at all, but some other module.

The error message that you have reported indicates that something is trying to be installed (quite probably the FEC module), and this suggests that there is still an FEC related file in the /admin/includes/auto_loaders/ and/or the /admin/includes/init_includes/ and/or the /admin/includes/installers/ folder.

I think that covers them all.

Cheers
RodG

Hi Rod ... Many thanks for your answer ...

You were right .. I found a folder in /admin/includes/installers/ folder called fec and forgot to delete those files.

Admin is back ... but now I have lost the main site ... and the weird thing is .. I have a FEC configuration menu under the Configuration tab that wasnt there before.

I have set everything there to false just in case that was the reason the site wouldnt load and seems to make no difference whatsoever. I'm fast getting to biting the bullet and just doing a bare new zc install from 5.1.4 and clearing all the what appears to be background and obsolete crap from the server :(

Is it possible to transfer things like metatags.php from one to the other ? .. The site has good google presence at the moment and I wouldn't like to destroy that aspect of the old site

Well, besides apologizing for not detail reading about how the removal was done, but it would seem to me that if the site is now down, that something "removed" may now be missing... Or perhaps not all files were removed and now something is "open" and causing a new error... Would have to wade through the other ones to probably figure it out, but the "new" error or at least one thrown within a few minutes of you trying to access the site should be "the one". :P

wallart studios:

Admin is back ... but now I have lost the main site ... and the weird thing is .. I have a FEC configuration menu under the Configuration tab that wasnt there before.

This won't cause any problems itself. It means one of two things.

1. When you ran the uninstall.sql script (as you stated previously) it failed in some way, and this is one of the 'remnants' left over. Or
2. **There is yet another FEC file in one of the folders I previously mentioned **that has finally managed to execute, and has inserted this data.

wallart studios:

I have set everything there to false just in case that was the reason the site wouldnt load and seems to make no difference whatsoever.

Setting things to 'false' isn't the same as being inactive or deactivated.

Database settings will never cause the problem you are currently describing. THe 'unwanted' FEC config menu will not cause the problems you are describing.

**The problem you currently have can only be related to one (or more) of the files. **

What do your log files tell you about this **new **problem.

wallart studios:

I'm fast getting to biting the bullet and just doing a bare new zc install from 5.1.4 and clearing all the what appears to be background and obsolete crap from the server :(

It is comments like this that piff me (and I'm sure many others) off no end. It is a slap in the face and makes me think that I've just wasted half hour of my time identifying the possible causes of your 1st problem and even more time attempting to guide you to a solution to the second problem.

wallart studios:

Is it possible to transfer things like metatags.php from one to the other ?

I consider this to be a stupid question. Trust me. I don't consider many questions to be stupid.
Do you seriously think that you are so 'unique' that you'd be the 1st person with a need/want to do this?

wallart studios:

.. The site has good google presence at the moment and I wouldn't like to destroy that aspect of the old site

Google ranks primarily on site content. It doesn't use the metatags at all.

So, where do you go from here? You could give me/us a 'fighting' chance to guide you through the current and any other further problems, OR you could do as you state and start afresh with a new install, which may go without a problem, or it could just as easily give you a different set of problems to fix.

The choice is yours.

Cheers
RodG

ps. Please ignore any snarky/arrogant/offensive comments that you may or may not perceive. The solution to your current problem has been highlighted.

Hi again Rod ......

I think you misunderstand me when I say about doing a bare install to get rid of the legacy crap and issues. I'm REALLY not trying to waste anyone's time here ... but SERIOUSLY ... you have no idea what kind of things I am dealing with.

Firstly .... there are at least 4 (yes I said 4) separate slideshows ... Supertracker ... FEC that seems to be leaving stuff behind even though I have tried to remove it .. the list just goes on and on. These were installed on a version 1.3.8a installation dating back to 2010 and I have no idea about compatibility of said modules in 1.5.4 (which incidentally ... as per the original post) ... the database has been updated to 1.5.4 but the core files of the site are still 1.3.8a.

What you are also seeming to forget ... is that not everyone is experienced enough to be able to just look at a zencart problem and be able to just say "that's easy to solve" ... and because they ask a question that to you may be "newbie" ... doesn't make it stupid .... just saying :blink:

I have a Business partner currently ripping me a new one as the site is down and we are losing sales with a website that I have been having drama's with for over a week now with no sales due to a server migration outside of my control by my hosting Company (original issue). So ... would you say I am under pressure here ? ... I think so :(

It is not my intention to upset anyone or waste their time. I am taking onboard everything that is said by every responder here and appreciative of ALL the assist .... trust me on that !!! ... But with my limited knowledge ... to me ? ... it seems as though everything I do is 1 step forward and another one back.

Again ... many thanks for your input, time and assist and I will look at the answers you have suggested.

Kind Regards

mc12345678:

Well, besides apologizing for not detail reading about how the removal was done, but it would seem to me that if the site is now down, that something "removed" may now be missing... Or perhaps not all files were removed and now something is "open" and causing a new error... Would have to wade through the other ones to probably figure it out, but the "new" error or at least one thrown within a few minutes of you trying to access the site should be "the one". :P

I would say you may be right mc12345678. I removed the files associated ... but maybe ... some of the installed files were just updated ones of core files that should be there originally and are now missing ... if files are not there ... they wont load I guess.

Ok Ladies and Gents .... an update for you :smile:

I have managed to solve the issue utilising the input of mc12345678 and RodG ... You gentlemen .... are beyond superb :cool:

I have to admit ... looking at what I was facing with .... a new install of over 500 product with 14,500 attributes in total (not enjoyable I can tell you) I am pleased to say I now have working admin and site at last :D

The result ?? ... I re uploaded the site from backup ... then instead of deleting ALL the files from the non working FEC ... I removed the installers as suggested by RodG. This has removed the module enough that checkout is now functioning and everything seems to be working ok.

Once again ... in conclusion ... mc12345678 and RodG ... my hearty thanks to you for your input ... Have a great weekend :laugh:

I've REALLY tried to stay out of this while you were fighting to get an operational site up for sales.

Now that you have, I have to tell you that you are running on "may-pops". That's Texas slang for really bald tires. In other words, I think your site is going to implode at any moment. Here's why (hopefully, I'm misreading something):

1. Your configure.php files you posted are NOT for the current version and are NOT secure if that is, in fact, the case.
2. You have leftover mod files that may be triggered at the least expected moment.
3. You apparently have changed file permissions where they should not have been. Hopefully, your server did not allow the change to 777 on anything!

If, as you stated, the sales from this site are important, I have the following suggestions.

1. Utilizing the instructions at https://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading to install the latest version in a new folder. Let's call it safety just for name's sake. You can name it whatever you like.
2. Create a new database just for the /safety site.
3. I would not bring over any files or templates from the existing site.
4. I would not do a database conversion/transfer now, either.
5. If your current site does not use a responsive template, I would install one that you like. If your current template is responsive, DO NOT copy it over to the /safety version as it may have some files that were changed by one of the old mods.
6. Load the latest versions of any mods you wish to use TO MAKE THE SITE FUNCTIONAL. If it is only for "pretty" or the much-abused "SEO" don't do it for now.
7. Add a product or two to thoroughly test the operation of the safety site.
8. TEST, TEST, TEST
9. Report back here, and we will help you get the data over from the running site.

I know you probably don't want to tackle this right now BUT, it's better to be a step ahead than have to go through all this under pressure.
:bigups:

I'm actually still a little baffled about the situation, as at least two different times we have gone down the question and answer path of what version the software is at and although I haven't actually been in a position to compare the current files with a vanilla install of ZC 1.5.4, so far all the right information is set to make things seem as if ZC 1.5.4 software is installed and that the database has been upgraded to match... So what has changed to indicate otherwise, or is it just that it wasn't personally done therefore must not have happened???

For the record.

wallart studios:

What you are also seeming to forget ... is that not everyone is experienced enough to be able to just look at a zencart problem and be able to just say "that's easy to solve" ...

The only time(s) that I've ever said anything remotely like that is AFTER the problem being discussed has actually be solved.

Please don't attribute what you may or may not have read elsewhere to something that I would never say (except on extremely rare occasions). This thread has not been one of those occasions. In fact I'd say the opposite. Yours have been one of the more complex issues to diagnose. That is the reason for my input in the 1st place. I leave the 'easy' problems to others.

wallart studios:

and because they ask a question that to you may be "newbie" ... doesn't make it stupid .... just saying :blink:

Again, you are reading more into what I wrote than it deserves. What I wrote was
"I consider this to be a stupid question.** Trust me. I don't consider many questions to be stupid"**.

I made an exception in your case because 1) The question wasn't in context in solving the problem. 2) You had already caused enough frustration.

Had you asked the exact same question in a thread of its own, or in almost any other context, I wouldn't have stated what I did. Instead, I would not only have answered the question, but would have also taken the time to explain what was needed to achieve the aim, or directed you to a resource that contained the information needed.

wallart studios:

It is not my intention to upset anyone or waste their time.

Nor is it mine (generally speaking).

wallart studios:

I am taking onboard everything that is said by every responder here and appreciative of ALL the assist .... trust me on that !!! ...

Well, no you didn't.

Several messages ago I wrote:
**It doesn't matter if the database DOES contain remnants of the installation because they will never cause any problems.
Whatever the cause of your problem, it ISN'T a database issue.

Now, unlike many responses, there was nothing 'wishy washy' about what I wrote here. There was no ifs, buts, or maybe's. I wrote it as the absolute fact that it is. Some/many people would consider this to be arrogance. I call it confidence. Either way, you didn't 'take it on board' because after taking care of one problem you then came back and wrote "I have set everything there to false just in case that was the reason the site wouldn't load and seems to make no difference whatsoever."
Which part of "it ISN'T a database issue" **didn't you understand?

wallart studios:

But with my limited knowledge ... to me ? ... it seems as though everything I do is 1 step forward and another one back.

I'll give you another absolute fact. Limited knowledge or not, what you say 'seems as though.....' doesn't just seem that way, more often than not it IS that way - and not just you, but for ALL of us. It is quite rare for multiple and/or changing symptoms to have a single cause or solution. Each symptom and problem needs to be tackled on its own merits as and when they arise. If you fail to accept this as fact you will be doomed to forever 'fixing' things by doing a complete re-installation and never advancing your knowledge or skills beyond that of a 'newbie'. Is that the person you really want to be? Not that there is anything wrong with that. There are many people that have no wish, need, or desire to advance beyond just knowing how to run and operate an online store, and that is perfectly acceptable.
However when people come into these forums asking questions about how to solve problems and issues (as you have done), I make the assumption that that person wishes to progress beyond this 'owner operator' stage, and I (like most others around here) go out of our way to help answer the questions and guide them along every step of the way to a final resolution. In other words, we make an 'investment' in our time, with the aim that in the longer term the persons we helping, will in turn, be in a position to help others.

Now, with this in mind, I have no qualms in saying that the way I word things will often upset and/or offend some people (especially the 'newbies'). It isn't that I intend this outcome, people take my words as they see fit (often distorting them in the process). I'm not a junior high school teacher. I'm a senior lecturer. You have been lectured. :-)

Cheers
RodG