Results 1 to 1 of 1

Could this be an error?

This is a discussion on Could this be an error? within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; i have see on database syntax, the table "products_groups" are not primary key with PRIMARY KEY (`customers_group_id`,`products_id`) thank you , ...

      
  1. #1
    New Member
    Join Date
    Dec 2009
    Posts
    24
    Rep Power
    0


    Question Could this be an error?

    i have see on database syntax,

    the table "products_groups" are not primary key with

    PRIMARY KEY (`customers_group_id`,`products_id`)

    thank you ,

    cause this primary is necessary and helpfull when merging with an old version of osCommerce.


    I have fix with this sql query:

    PHP Code:
     
    ALTER TABLE 
    `products_groups`
      
    DROP PRIMARY KEY,
       
    ADD PRIMARY KEY(
         `
    customers_group_id`,
         `
    products_id`); 
    Last edited by gasse1014life; 12-15-2009 at 11:33 PM.

Similar Threads

  1. Replies: 10
    Last Post: 03-28-2009, 01:23 PM
  2. Error on admin page, no error message....
    By ryoyin in forum osCmax v2 Installation issues
    Replies: 1
    Last Post: 08-21-2008, 01:31 AM
  3. SEO URLS -> error 500: Internal server error ...
    By Moritz100 in forum osCMax v1.7 Installation
    Replies: 0
    Last Post: 03-18-2005, 01:11 AM
  4. Newsletter!?, ERROR: 1064 - You have an error in your SQL...
    By calle in forum osCommerce 2.2 Modification Help
    Replies: 2
    Last Post: 12-14-2004, 03:40 AM
  5. New Installation Parse error: parse error, unexpected T_STRI
    By Anonymous in forum osCMax v1.7 Installation
    Replies: 5
    Last Post: 07-09-2004, 07:06 AM

Tags for this Thread

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
  •