#8 slash-all.sql generates error with myAdmin

enhancement
closed-wont-fix
nobody
5
2000-09-16
2000-09-10
Anonymous
No

When pasting the content of slash-all.sql into myAdmin, some errors are generated (I know this is a myAdmin bug but it seems to me that losta phpslash lovers use myadmin as well) :
Every INSERT line containing addslashed quote and/or double quote, every hash generates the same error.

quick hack :

1) search-> /' replace-> ` (inversed quote)
2) search-> /" replace-> (nothing)
3) search-> # replace-> colour name (litterar)

It allowed me to add all tables/entries in one copy/paste.
Hope this will help

Tobozo

Discussion

  • Ajay Sharma
    Ajay Sharma
    2000-09-10

    • status: open --> open-wont-fix
     
  • Ajay Sharma
    Ajay Sharma
    2000-09-10

    The reason that you're getting a problem in phpMyAdmin is that you need to enable gpc_magic_quotes. PHPSlash doesn't use magic_quotes, so even though I use phpMyAdmin a lot, the perferred way to import the data is via the command line.

     
  • site_logolarge, poll_fontcolor and site_title don't have the correct spelling (missing underscore) or dont exist psl_vars list

     
  • Ajay Sharma
    Ajay Sharma
    2000-09-16

    • status: open-wont-fix --> closed-wont-fix
     
  • Ajay Sharma
    Ajay Sharma
    2000-09-16

    Before I close this ticket, I just want to metion that if you're running PHP as a module you can configure the gpc_magic_quotes via an .htaccess file. For PHP4 this is what I put in the httpd.conf file:

    <Directory "/home/httpd/htdocs/mysql">
    Options Indexes MultiViews
    AllowOverride All
    Order allow,deny
    Allow from all
    </Directory>

    And this is the php line in the .htaccess

    php_flag magic_quotes_gpc On

    That should do it. Make sure you read the Apache/PHP docs to find out some more info about setting up the .htaccess file.