Your message dated Wed, 11 Oct 2006 16:09:36 +0100
with message-id <[EMAIL PROTECTED]>
and subject line Removed
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
Package: spip
Version: 1.7.0-1
Severity: grave
spip-configure fails horribly at creating instances. When closing the wizard
with the choice "DONE", spip-configure performs the requested actions, then
aborts with this message:
ERROR 1064 at line 1: 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 ' htpass="$apr1$1ZMnE/..$LKhkiPgCeXEFP6pKbZIe..", statut="0minir
for all I can see, the resulting instance is unable to run, and the front
page shows:
* on the left "Mon site SPIP, plan du site, résumé,espace privé, the
SPIP logo"
* on the right, twice the folowing message:
<BOUCLE_article_un>
Erreur dans la requête envoyée à MySQL :
SELECT
articles.id_article,articles.id_rubrique,articles.id_secteur,articles.surtitre,articles.titre,articles.soustitre,articles.date,articles.date_redac,articles.date_modif,articles.visites,articles.popularite,articles.statut,articles.accepter_forum,articles.lang,articles.id_trad,articles.texte,articles.chapo,articles.descriptif
FROM spip_articles AS articles WHERE articles.statut='publie' ORDER BY
articles.date DESC LIMIT 0,2
Unknown column 'articles.lang' in 'field list'
</BOUCLE_article_un>
issuing "SHOW CREATE TABLE spip_article;" on the "aspique" database returns
the following:
CREATE TABLE `Spip_articles` (
`id_article` bigint(21) NOT NULL auto_increment,
`Surtitre` text NOT NULL,
`Titre` text NOT NULL,
`Soustitre` text NOT NULL,
`id_rubrique` bigint(21) NOT NULL default '0',
`Descriptif` text NOT NULL,
`Chapo` mediumtext NOT NULL,
`Texte` longblob NOT NULL,
`Ps` mediumtext NOT NULL,
`Date` datetime NOT NULL default '0000-00-00 00:00:00',
`Statut` varchar(10) NOT NULL default '0',
`id_secteur` bigint(21) NOT NULL default '0',
`Maj` timestamp(14) NOT NULL,
`Export` varchar(10) default 'oui',
`Date_redac` datetime NOT NULL default '0000-00-00 00:00:00',
`Visites` int(11) NOT NULL default '0',
`Referers` int(11) NOT NULL default '0',
`Popularite` double NOT NULL default '0',
`Accepter_forum` char(3) NOT NULL default '',
`Auteur_modif` bigint(21) NOT NULL default '0',
`Date_modif` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id_article`),
KEY d_rubrique (`id_rubrique`),
KEY d_secteur (`id_secteur`),
KEY `Statut` (`Statut`,`Date`)
) TYPE=MyISAM
I don't know what type the "lang" column should be, so I can hardly ALTER
the table myself. At the very least, spip-configure should be upgraded to
create the schema the bunch of .php files expect to find.
Furthermore, trying to access the /ecrire URL won't do me much good, as the
only line in the spip_auteurs table does not correspond to the documented
defaults:
mysql> select nom,email,htpass from spip_auteurs;
+------------+-------+------------------------------------+
| nom | email | htpass |
+------------+-------+------------------------------------+
| SPIP admin | | $1$EuLEDaWX$W9r0OHqCCGQiHIh79/k2a1 |
+------------+-------+------------------------------------+
constrast with this sentence from the README.Debian: "
In the SPIP database, the admin user is "spip", password "spippass" by
default. You may have
to change it in the "authors" panel.
"
I wonder if the error message above is not output while spip-configure tries
to create the "spip/spippass" user?
Overall, because of this problem Debian's spip package as currently shipped
in sid is totally unusable for me, hence the severity.
-- Cyrille
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing')
Architecture: i386 (i586)
Kernel: Linux 2.6.5
Locale: LANG=french, LC_CTYPE=french (ignored: LC_ALL set to [EMAIL PROTECTED])
Versions of packages spip depends on:
ii apache 1.3.31-1 Versatile, high-performance HTTP s
ii debconf 1.4.25 Debian configuration management sy
ii debianutils 2.8.2 Miscellaneous utilities specific t
ii mysql-client 4.0.20-2 mysql database client binaries
ii php4 4:4.3.4-4 A server-side, HTML-embedded scrip
ii php4-mysql 4:4.3.4-4 MySQL module for php4
ii wwwconfig-common 0.0.34 Debian web auto configuration
mysql-server is 4.0.20-2 and I'm actually using apache2-mpm-prefork 2.0.49-1
(though this is not the problem here)
-- debconf information:
* spip/database/spip: spip
spip/skeleton:
spip/fqdn: ${site}
spip/skeleton/spip: Default
* spip/new_site_name: aspique
spip/same_dbname:
* spip/fqdn/spip: http://www.aspique.org
* spip/purge_files: false
* spip/username/spip: myadmin
spip/instances_to_delete: aspique
spip/database:
* spip/root_mysql: myadmin
spip/instances: spip aspique
spip/mismatch:
* spip/purge_db: false
* spip/mysql_server: localhost
spip/username: spip
spip/no_mysql_message:
* spip/select_site: aspique
* spip/cannot_create:
* spip/edit_sites: DONE
spip/no_mysql: false
--- End Message ---
--- Begin Message ---
spip has been removed because it's buggy, has never been part of a
stable release and security issues, see #384385
--
Martin Michlmayr
http://www.cyrius.com/
--- End Message ---
