Exclamations Marks & Multiple query_factory.php Warnings

[Stenrique]

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

[dbltoe]

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.

[Stenrique]

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

[dbltoe]

Have you been bad and messed with the database
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.

[Stenrique]

Have you been bad and messed with the database
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

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

[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 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.

[Stenrique]

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 . 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.

[dbltoe]

the semicolon is correct and...
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
What happens if you switch templates? Does the problem go away?

[Stenrique]

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

Thanks for your help dbltoe, I appreciate it.