Link exchange sidebox and page-text customization

[moksha]

Thanx clydejones, now I can read the file (sometimes I just can't get to the obvious!). I'll try upgrading now... cross fingers for me!
Thanx again!! :))

[moksha]

I made such an idiotic mistake... I first made the "uninstall" sql patch run (don't ask me why)!! After doing this I ran the "upgrade" sql patch and uploaded all the files included in the upgrade folder... but when refreshing my site's page half of the site was obviously gone! So I restored my backup file and everything went back into place... except for the category links... when clicking on them from the links box now I get this message:

"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
in:
[select count(l.links_id) as total from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '2'order by ]"

Running the uninstall sql patch first must have deleted something necessary for the upgrading process... I think. How can I fix this?

HELP!!

http://www.thequintessence.biz/index...ain_page=links

(MySQL server version: 5.0.51a; Zen Cart version: 1.3.8... don't know if this can help...)

[clydejones]

I made such an idiotic mistake... I first made the "uninstall" sql patch run (don't ask me why)!! After doing this I ran the "upgrade" sql patch and uploaded all the files included in the upgrade folder... but when refreshing my site's page half of the site was obviously gone! So I restored my backup file and everything went back into place... except for the category links... when clicking on them from the links box now I get this message:

"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
in:
[select count(l.links_id) as total from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '2'order by ]"

Running the uninstall sql patch first must have deleted something necessary for the upgrading process... I think. How can I fix this?

HELP!!

http://www.thequintessence.biz/index...ain_page=links

(MySQL server version: 5.0.51a; Zen Cart version: 1.3.8... don't know if this can help...)

Uninstall does exactly what it says - it will uninstall everything.

Since you restored a backup

Open the upgrade folder and run the update_links_manager.sql

[moksha]

It works! I knew you could fix this. You're great!!
Thanx SO MUCH!

[moksha]

Ok, have added a few descriptions on the links pages now... but here:

http://www.thequintessence.biz/index...e=links_submit

... the whole info box has disaligned the right side of my site, I think it's too wide. Where can I change the box size and the font style? (I'm using comic sans).

Then, in the links help popup box the black background is still there and you can't read the text. Must I add some code in my stylesheet to fix this?

Also, here:

http://www.thequintessence.biz/index...ain_page=links

... the category links aren't properly aligned. Don't have a clue what to do here.

Thanx for any suggestion! :)

[clydejones]

Ok, have added a few descriptions on the links pages now... but here:

http://www.thequintessence.biz/index...e=links_submit

... the whole info box has disaligned the right side of my site, I think it's too wide. Where can I change the box size and the font style? (I'm using comic sans).

Then, in the links help popup box the black background is still there and you can't read the text. Must I add some code in my stylesheet to fix this?

Also, here:

http://www.thequintessence.biz/index...ain_page=links

... the category links aren't properly aligned. Don't have a clue what to do here.

Thanx for any suggestion! :)

I checked the links you mentioned in (FF, Opera, Safari, and IE7) and didn't notice any misalignment(s)

To change the font style, open the links.css and links_submit.css stylesheets and make your necessary edits.

[moksha]

Strange, 'cause I also use IE7 and can see the misalignments... haven't you noticed the right sideboxes falling out a little from the main body on the "Links submission" page (https://web52.secure-secure.co.uk/th...e08f2ccd982f)? I can see this right under my "who's online" box and on top of the "currencies" box...

Also, on the "View All Links" page (http://www.thequintessence.biz/index...18e08f2ccd982f), the link "eShops" should be under "Blogs"; "Information" under "Clothes and Costumes"; and "Services" under "Directories"... they seem to appear one after the other but as if missing a step...

What can I do for that black background in the "Links Help" popup boxes, clyde?

Thanx for the css tip, I've changed the font style... it's looking good :)