Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2009
    Location
    Oxford UK
    Posts
    192
    Plugin Contributions
    0

    Default Please help with 4 minor problems

    Hi all zenners,

    I have 4 minor pronlems and was wondering if anyone could help me.

    1. i get this code when trying to use manufacturers_img.php

    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 'BOX_MANUFACTURER_MAX_LOGOS' at line 6
    in:
    [select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from manufacturers m left join manufacturers_info mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1') ORDER BY RAND() LIMIT 0,BOX_MANUFACTURER_MAX_LOGOS]

    2. When i refresh the page it goes to the top on all browsers and computers. I want it to refresh and go to the same part of the page i was looking at

    3. When i search for products i want to be able to FILTER results by price lowest or highest first not a list of alphabetical letters as all my products in each category start with the same letter.

    4. I have the alexa widget in the footer but it stays to the left and i want it in the centre.


    I have searhhed the forums and can find threads on some of these issues but there is no answers.

    Please help zenners.

    Thanks and kind regards from the GMRM team.

    p.s my site is my signature so you will see what i mean.

  2. #2
    Join Date
    Sep 2007
    Location
    Colorado, USA
    Posts
    68
    Plugin Contributions
    0

    Default Re: Please help with 4 minor problems

    Hi GMRM,

    1. The error is being cause by the variable "BOX_MANUFACTURER_MAX_LOGOS" not being defined. It should be an integer so that your SQL statement looks like this:

    select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from manufacturers m left join manufacturers_info mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1') ORDER BY RAND() LIMIT 0,5

    * BOX_MANUFACTURER_MAX_LOGOS = 5

    I'm not familiar with this variable name though, do you have a module installed that could be causing this error?

    Can you post a link to the site so we can take a look at it?

    - Danny

  3. #3
    Join Date
    Apr 2009
    Location
    Oxford UK
    Posts
    192
    Plugin Contributions
    0

    Default Re: Please help with 4 minor problems

    Hi Danny thanks for the reply , my site is my signature as stated in my origanal post. It is a mod off here called manufactures_img.

    i know its installed right , just dont know why i'm getting this code. Also i cannot show you live on site as i run a business and it would look unprofessional if i left that where the block should be. Thats the code it shows where the block should be

  4. #4
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: Please help with 4 minor problems

    It's better to ask one question at a time. Multiple questions are much more likely to go unanswered and are less useful to other users with the same problems as the thread titles are too general.

    But let's have a go ...

    1. The mod (actually the "Sidebox for list Manufacturers logos") is defective. It's author appears to have forgotten to include the definition for BOX_MANUFACTURER_MAX_LOGOS. As a quick and dirty I recommend that you simply replace it with a numerical value in the module file.

    2. This is how web pages work when refreshed.

    3. Sounds like you need to turn of the alpha sorter in the Admin. Users can already sort by price, ascending or descending, by clicking on the word price in the listing title bar. You may want to add some styling or change the text to make that more obvious.

    4. Insert the following into your stylesheet
    .AlexaSiteStatsWidget {
    display:block;
    width:120px;
    margin: 10px auto;
    }
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  5. #5
    Join Date
    Sep 2007
    Location
    Colorado, USA
    Posts
    68
    Plugin Contributions
    0

    Default Re: Please help with 4 minor problems

    well said kuroi

  6. #6
    Join Date
    Apr 2009
    Location
    Oxford UK
    Posts
    192
    Plugin Contributions
    0

    Default Re: Please help with 4 minor problems

    Kuroi you are an asset to the zen community. I truly appreciate your help.

    Many thanks from the GMRM team

 

 

Similar Threads

  1. Problems with Newletter...Please help
    By jjmondoro in forum General Questions
    Replies: 1
    Last Post: 13 Mar 2013, 12:55 PM
  2. Problems with the layout in boxes Please help
    By freeyourmobile in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 2 Jun 2008, 02:28 AM
  3. problems with orders, please help
    By shawnspookcity in forum Managing Customers and Orders
    Replies: 21
    Last Post: 13 May 2007, 02:12 PM
  4. 2 minor layout changes (help please related)
    By recordshow in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 7 Dec 2006, 02:45 AM
  5. minor problems with gift vouchers
    By poosk in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 1
    Last Post: 30 May 2006, 08:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg