Forums / Upgrading from 1.2 to 1.3.x / Exclamations Marks & Multiple query_factory.php Warnings

Exclamations Marks & Multiple query_factory.php Warnings

Locked

Views: 2,914

Results 1 to 9 of 9
This thread is locked. New replies are disabled.
1 Aug 2006, 12:48 AM
#1
stenrique avatar

stenrique

Zen Follower

Join Date:
Apr 2005
Posts:
355
Plugin Contributions:
0

Exclamations Marks & Multiple query_factory.php Warnings

Hi,

I am currently upgrading from 1.2.7d to 1.3.0.2. I opt to upgrade by patching the database from 1.2.7d to 1.3.0.2 while installing fresh 1.3.0.2 compliant mods.

I'm getting some errors first of which are:

  1. Exclamation marks for all the links under the Information sidebox. You might want to visit my website to get a clearer picture. The Information sidebox is located near the bottom right hand side.

  2. If you click on the "About Us" link in the Information sidebox, you wld encounter a series of error messages at the top of the page.

Cld anyone pls. advise? TIA

1 Aug 2006, 5:23 AM
#2
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,885
Plugin Contributions:
20

Re: Exclamations Marks & Multiple query_factory.php Warnings

First, if you did not use the FULL fileset for 1.3.0.2, you must.
Second, if you did not use the database upgrade feature in ZC_Install, you will not properly update the database.
Third, what is> <a href="http://www.sens***ven.com/sens***ven1302/index.php?main_page=about_us"><img src="includes/templates/sens***ven/images/bc_info.gif" alt="" width="16" height="16" />About Us</a></li>

That's what's giving you the yellow triangle.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

1 Aug 2006, 6:06 PM
#3
stenrique avatar

stenrique

Zen Follower

Join Date:
Apr 2005
Posts:
355
Plugin Contributions:
0

Re: Exclamations Marks & Multiple query_factory.php Warnings

Thanks for the pointer dbltoe, found that it was caused by overwriting a wrong file. As for the upgrade, I utilized the full file-set of zc 1.3.0.2 for it and for the DB upgrade too. So for now, I have an upgraded DB (1.2.7d -> 1.3.0.2) and a fresh set of files from zc 1.3.0.2.

Hope the additional info. clear up the picture a little. Any advices? TIA

1 Aug 2006, 6:36 PM
#4
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,885
Plugin Contributions:
20

Re: Exclamations Marks & Multiple query_factory.php Warnings

Have you been bad and messed with the database:D
I'm seeing a lot of "select as.." and multiple prefixes to products_id.

You have apparently broken the sql query and changed some variable names. One of which is needed for the query_factory.php.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

1 Aug 2006, 8:43 PM
#5
stenrique avatar

stenrique

Zen Follower

Join Date:
Apr 2005
Posts:
355
Plugin Contributions:
0

Re: Exclamations Marks & Multiple query_factory.php Warnings

dbltoe:

Have you been bad and messed with the database:D
I'm seeing a lot of "select as.." and multiple prefixes to products_id.

You have apparently broken the sql query and changed some variable names. One of which is needed for the query_factory.php.

I have only extended the "products_model" column in "Products" table, and add/modify tables/columns as I installed mods. Other than that, I have been behaving :D

How may I find the "select as..." & multiple prefixes to products_id? Perhaps I broke something w/o realizing it :ohmy: TIA

1 Aug 2006, 9:36 PM
#6
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,885
Plugin Contributions:
20

Re: Exclamations Marks & Multiple query_factory.php Warnings

Looks like you've dropped back and regrouped with a new custom template and all is working.

Small glitches in your stylesheet.css on line 25> BODY {

/background-color: #e5edf5;/
background-color: #FF00FF;
color: #000000;
margin: 0px;
margin-bottom: 10px;
padding: 0px;
font: 10pt Verdana, Arial, Helvetica, sans-serif;
/* background-image:url(../images/bkgrd_orangy_flower_drawing.gif);/
/background-image:url(../images/plaid1.jpg);/
background-image:url(../images/pink09.jpg);
/background-image:url(../images/pink18.jpg);
background-image:url(../images/pink48.jpg);
/
/
background-image:url(../images/SSPinkPlaid.jpg); */
}The item in red is missing.

Also note how the commenting is done in that section and in the very top of the stylesheet.

You attempt to comment out some entries on lines 385, 386, and 499. Rule of thumb is
/* Starts single line comment
/** Starts multi-line comment

  • or // Starts other lines in multi-line comment
    */ At the end of the single or end of last multi-line ends the comment.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

1 Aug 2006, 9:58 PM
#7
stenrique avatar

stenrique

Zen Follower

Join Date:
Apr 2005
Posts:
355
Plugin Contributions:
0

Re: Exclamations Marks & Multiple query_factory.php Warnings

dbltoe:

Looks like you've dropped back and regrouped with a new custom template and all is working.

Small glitches in your stylesheet.css on line 25The item in red is missing.

Also note how the commenting is done in that section and in the very top of the stylesheet.

You attempt to comment out some entries on lines 385, 386, and 499. Rule of thumb is
/* Starts single line comment
/** Starts multi-line comment

  • or // Starts other lines in multi-line comment
    */ At the end of the single or end of last multi-line ends the comment.

Pardon me but I am a little lost :dontgetit . I can't quite see the item(s) in red except for the semi-colon in this statement: /background-color: #e5edf5;/

Also, the stylesheet.css that was quoted in your posting is that of my live site rather than the ver 1.3.0.2 that I am upgrading to. Cld you elaborate a little more? Thanks for your patience.

1 Aug 2006, 10:10 PM
#8
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,885
Plugin Contributions:
20

Re: Exclamations Marks & Multiple query_factory.php Warnings

the semicolon is correct and...
:oops: I instinctively dropped to the root to check things out. those glitches are in the main site.

ON THE ONE I'M SUPPOSED TO BE LOOKING AT:shocking:
What happens if you switch templates? Does the problem go away?

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

2 Aug 2006, 2:29 PM
#9
stenrique avatar

stenrique

Zen Follower

Join Date:
Apr 2005
Posts:
355
Plugin Contributions:
0

Re: Exclamations Marks & Multiple query_factory.php Warnings

I have tried switching to the Classic template but the same error appears. I am really baffled :cry:

Thanks for your help dbltoe, I appreciate it.