Errors Adding Products

Discussion in 'Troubleshooting' started by jbair, May 25, 2010.

  1. jbair

    jbair New Member

    Joined:
    Sep 16, 2008
    Messages:
    2
    MYSQL ERROR:
    Duplicate entry '0' for key 1
    in query:
    INSERT INTO amember_folders (path, url, method, product_ids, files_content) VALUES ('/var/www/html/ascii/', 'http://var.arrc.com/ascii/', 'new_rewrite', '2', 'a:1:{s:9:\".htaccess\";s:697:\"########### AMEMBER START #####################\r\nOptions +FollowSymLinks\r\nRewriteEngine On\r\n\r\n## allow access for product #2 \r\nRewriteCond %{HTTP_COOKIE} amember_nr=([a-zA-Z0-9]+)\r\nRewriteCond /var/www/html/amember/data/new_rewrite/%1-2 -f \r\nRewriteRule ^(.*)$ - [L]\r\n\r\n## if user is not authorized, redirect to login page\r\n# BrowserMatch \"MSIE\" force-no-vary\r\nRewriteCond %{QUERY_STRING} (.+)\r\nRewriteRule ^(.*)$ http://var.arrc.com/amember/plugins/protect/new_rewrite/login.php?v=-2&url=%{REQUEST_URI}?%{QUERY_STRING} [L,R]\r\nRewriteRule ^(.*)$ http://var.arrc.com/amember/plugins/protect/new_rewrite/login.php?v=-2&url=%{REQUEST_URI} [L,R]\r\n########### AMEMBER FINISH ####################\";}')
  2. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    It seems that amember_folders table in MySQL database is corrupted.
    I belive that folder_id is not set as auto_increment You can fix this yourself from phpMyAdmin or contact us in helpdesk and provide access to hosting CP so we will fix this.

Share This Page