Error upgrade 1.3.7 to 1.3.8a

[DrByte]

http://www.zen-cart.com/forum/showthread.php?t=82998

[williamb]

I figured instead of cross threading other peoples issues I would continue my own with reference points from your reference post answer in the previous post.

http://www.zen-cart.com/forum/showthread.php?t=82998
It's trying to insert a record that apparently already exists.
Did you run the database upgrade twice for some reason?

The answer is no, I did not try running it again.

Run this using the SQL Patch tool in the Admin->Tools menu:
Code:

DELETE from query_builder where query_name = 'Customers who have never completed a purchase';

Then you should be able to redo the database upgrade ... again.

I can't do that if I have no access to the admin panel in the application, there is just a blank screen when I try to access the admin or the client side. HOWEVER I believe I can do this from my phpMyAdmin access, should I do that?

[DrByte]

You can use phpMyAdmin.
You may need to add your DB_PREFIX value to the beginning of the table name if you are using prefixes in your site.

[williamb]

hmmm small problem, that query does not exist in the database. I have the following queries.

1) All customers
2) All Newsletter Subscribers
3) Dormant Customers (>3month Subscribers)
4) Active Customers in past 3 months (Subscribers)
5) Active Customers in past 3 months (Regardless of S...)
6) Administrator

I also did a look up for it and got this

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0006 sec)
SQL query:
SELECT *
FROM `zen_query_builder`
WHERE `query_name` LIKE CONVERT( _utf8 'Customers who have never completed a purchase'
USING latin1 )
COLLATE latin1_swedish_ci
LIMIT 0 , 30

Any other ideas?

[DrByte]

Your first post says the table name is "query_builder" but your last post talks about "zen_query_builder".
Sounds like you're running things on different sets of tables.

[williamb]

HOLY C#$* Some how I installed it all over again but using ZEN at the forefront....okay I found it and was able to do the command

DELETE from query_builder where query_name = 'Customers who have never completed a purchase';

Question now is how do I drop all those tables that start with "ZEN_" ???

AND
Going to http://domainname.com/zc_install/index.php shows nothing but a blank page now.

Should I re-upload all the 1.3.8 files?

[DrByte]

You'll have to manually remove the extra files using your phpMyAdmin console.

As for the blank screen ... I suppose that's likely a result of a bad edit to a file or incomplete uploads.