osCmax v2.5 User Manual
Results 1 to 8 of 8

HELP Hear About Us mod database table not defined

This is a discussion on HELP Hear About Us mod database table not defined within the osCommerce 2.2 Discussion forums, part of the osCommerce 2.2 Forums category; Installed the mod - How_Did_You_Hear_1.5.2. Everything perfect - it is actually working but there is a problem in the admin ...

      
  1. #1
    Member
    Join Date
    Apr 2009
    Posts
    57
    Rep Power
    4


    Default HELP Hear About Us mod database table not defined

    Installed the mod - How_Did_You_Hear_1.5.2. Everything perfect - it is actually working but there is a problem in the admin site - has anyone installed this and had the same problem.

    There is a sources_other table that definitely exists and is populated but why is the code referring to table_sources_other - is this an error as there are lots of instances of it.

    Also, can't find anywhere in the admin where I can manipulate the drop down box hear about us items.

    Help as I can't see my customers

    -------------------------
    Customers
    1146 - Table 'XXXX.TABLE_SOURCES_OTHER' doesn't exist

    select sources_other_name as sources_name from TABLE_SOURCES_OTHER where customers_id = '19'

    [TEP STOP]
    -------------------------

  2. #2
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,907
    Rep Power
    568


    Default Re: HELP - urgent - re Hear About Us mod

    You missed an installation step. Look over the instructions, there is a step that has you edit the admin/includes/database_tables.php file, you need to add a constant for TABLE_SOURCES_OTHER that matches the name of the table.
    Michael Sasek
    osCMax Developer


    osCmax Installation Service
    - Have our professionals install osCmax on your server - same day service!
    osCmax 2.5 User Manual - the must have beginners guide to osCmax v2.5

    Stay Up To Date with everything osCMax:
    Free osCmax Newsletters - Security notices, New Releases, osCMax News
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    Member
    Join Date
    Apr 2009
    Posts
    57
    Rep Power
    4


    Default Re: HELP Hear About Us mod database table not defined

    Hi Michael,

    Have gone through and installed it all again - still get the same error. In the database_tables.php I have added the 2 lines as per the instructions:

    ------------------###############---------------------
    In catalogadminincludesdatabase_tables.php

    Add:
    define('TABLE_SOURCES', 'sources'); //rmh referrals
    define('TABLE_SOURCES_OTHER', 'sources_other'); //rmh referrals
    ---------------------------------------------------------------

    and still get the same error.

    The tables are definitely in the database and populated from the front end. I have no idea where else to look

    Cheers

  4. #4
    Member
    Join Date
    Apr 2009
    Posts
    57
    Rep Power
    4


    Default Re: HELP Hear About Us mod database table not defined

    Been through it all again for the 3rd time - still no luck.

    the other thing I can't find in the admin is where to actually change or add the Hear about us items - there is no link to click on - not sure where to do this and it doesn't mention anything in the instructions as far as I can see.
    GEtting no responses on the official forum either.

  5. #5
    Member
    Join Date
    Apr 2009
    Posts
    57
    Rep Power
    4


    Default Re: HELP Hear About Us mod database table not defined

    Ok - got it working now in the Admin - can see the referrals under customers which is good - don't know what I did but it now works.

    But, still not showing anywhere in the admin is somewhere where you can change or add to the Heard About Us items.

  6. #6
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22


    Default Re: HELP Hear About Us mod database table not defined

    Your admin LEVEL may not be setup to display that option.

    Administrator => File Access
    Click on the box you want it added to. then use the Store Files button and add the fle you want osCMax to "allow access" to.

    Then to setup specific user groups to see it on there menus
    Administrator => Member Groups => Groups
    Select the group to change and click "NEW Permissions".
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!

  7. #7
    Member
    Join Date
    Apr 2009
    Posts
    57
    Rep Power
    4


    Default Re: HELP Hear About Us mod database table not defined

    Thanks a lot - learn something every day .

    Did all that and can see the reports on hear about us sources. Only thing is I can't find the file or anywhere where you can actually add the sources via the admin. Will keep looking but eluding me so far.

    Cheers

  8. #8
    Member
    Join Date
    Apr 2009
    Posts
    57
    Rep Power
    4


    Default Re: HELP Hear About Us mod database table not defined

    Don't worry - all sorted - going a bit batty after staring at the code for hours

    Thanks again

Similar Threads

  1. How Did You Hear About Us
    By michael_s in forum New osCommerce Contributions
    Replies: 2
    Last Post: 06-28-2009, 06:06 AM
  2. Create database table phpAdmin
    By Detritus in forum osCmax v2 Installation issues
    Replies: 2
    Last Post: 04-04-2008, 10:53 AM
  3. How Did You Hear About Us
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 05-15-2007, 11:11 AM
  4. How Did You Hear About Us
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 02-21-2007, 02:00 PM
  5. How Did you Hear About Us v1.2---contribution
    By Christy in forum osCmax v1.7 Discussion
    Replies: 7
    Last Post: 04-01-2005, 04:45 AM

Bookmarks

Posting Permissions

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