0
Welcome Guest! Login
0 items Join Now

SQL errors during running of joomla.sql

Last Post
Search Topic

  • SQL errors during running of joomla.sql

    Posted 15 years 7 months ago
    • I have already posted this in the Joomla forum but I thought I would post here in case someone has experience with my issue.

      Google yielded only one other person who got this error (back in 2008) with no resolution, so here it is again:

      -bash-3.00# ./mysql -p joomla < /opt/apache/htdocs/joomla/installation/sql/mysql/joomla.sql
      Enter password:
      ERROR 1064 (42000) at line 829: 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 'INT(11) NOT NULL,
      `name` VARCHAR(100) NOT NULL,
      `url` TEXT NOT NULL,
      `sefurl`' at line 2
      -bash-3.00#

      The other user who received this error was on Ubuntu, but we're actually running Solaris 10 here. The install script worked fine on an older version of mysql (4.0.31), but I'd vastly prefer to use 5.X. Specs are as follows:

      Release version: 1.5.14
      Localhost,Remote Host: shared server, Solaris
      System Information: PHP 5.2.10, Apache 2.2.11, MySQL 5.1.38
      Your OS: Solaris 10
      The problem in detail: Installation script failing
      What you have tried to solve the issue: Different versions of mysql (4.0.31 worked but I need 5 for other apps, 5.0.67 also didn't work)
      What searches you have done/information that may be related: Google turned up an old, unanswered thread
      Add screenshots to the post: N/A
      Is .htaccess file in use? N/A
      What settings are currently set? N/A

      Thanks,

      Jeanette
    • http://www.jeanettekwok.com
    #390367

  • Re: SQL errors during running of joomla.sql

    Posted 15 years 7 months ago
    #390471

  • Re: SQL errors during running of joomla.sql

    Posted 15 years 7 months ago
    #390744

Time to create page: 0.062 seconds