Opened 3 years ago
Closed 2 years ago
#1487066 closed Bugs (fixed)
Cannot use a scalar value
| Reported by: | snyfir | Owned by: | |
|---|---|---|---|
| Priority: | 5 | Milestone: | 0.5-stable |
| Component: | PHP backend | Version: | 0.4.2 |
| Severity: | normal | Keywords: | |
| Cc: |
Description
In my log file i have many messages like this :
[18-Oct-2010 19:31:04] PHP Warning: Cannot use a scalar value as an array in /homez.18/autofrg/roundcube_0.4.2/www/program/steps/mail/func.inc on line 580
Change History (4)
comment:1 Changed 3 years ago by alec
- Component changed from Other to PHP backend
- Milestone changed from later to 0.5-beta
comment:2 Changed 3 years ago by snyfir
Hello,
I use php 5.2 with mysql. It append when i send a mail for example.
This is my DB :
-- phpMyAdmin SQL Dump -- version OVH -- http://www.phpmyadmin.net -- -- Serveur: mysql5 -- Généré le : Lun 25 Octobre 2010 à 18:51 -- Version du serveur: 5.0.90 -- Version de PHP: 5.2.6-1+lenny8 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Base de données: `kwrdrcube` -- -- -------------------------------------------------------- -- -- Structure de la table `cache` -- CREATE TABLE IF NOT EXISTS `cache` ( `cache_id` int(10) unsigned NOT NULL auto_increment, `cache_key` varchar(128) NOT NULL, `created` datetime NOT NULL default '0000-00-00 00:00:00', `data` longtext NOT NULL, `user_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`cache_id`), KEY `user_cache_index` (`user_id`,`cache_key`), KEY `created_index` (`created`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Structure de la table `contactgroupmembers` -- CREATE TABLE IF NOT EXISTS `contactgroupmembers` ( `contactgroup_id` int(10) unsigned NOT NULL, `contact_id` int(10) unsigned NOT NULL default '0', `created` datetime NOT NULL default '1000-01-01 00:00:00', PRIMARY KEY (`contactgroup_id`,`contact_id`), KEY `contact_id_fk_contacts` (`contact_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Structure de la table `contactgroups` -- CREATE TABLE IF NOT EXISTS `contactgroups` ( `contactgroup_id` int(10) unsigned NOT NULL auto_increment, `user_id` int(10) unsigned NOT NULL default '0', `changed` datetime NOT NULL default '1000-01-01 00:00:00', `del` tinyint(1) NOT NULL default '0', `name` varchar(128) NOT NULL default '', PRIMARY KEY (`contactgroup_id`), KEY `contactgroups_user_index` (`user_id`,`del`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Structure de la table `contacts` -- CREATE TABLE IF NOT EXISTS `contacts` ( `contact_id` int(10) unsigned NOT NULL auto_increment, `changed` datetime NOT NULL default '0000-00-00 00:00:00', `del` tinyint(1) NOT NULL default '0', `name` varchar(128) NOT NULL default '', `email` varchar(128) NOT NULL, `firstname` varchar(128) NOT NULL default '', `surname` varchar(128) NOT NULL default '', `vcard` text NOT NULL, `user_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`contact_id`), KEY `user_contacts_index` (`user_id`,`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=243 ; -- -------------------------------------------------------- -- -- Structure de la table `identities` -- CREATE TABLE IF NOT EXISTS `identities` ( `identity_id` int(10) unsigned NOT NULL auto_increment, `del` tinyint(1) NOT NULL default '0', `standard` tinyint(1) NOT NULL default '0', `name` varchar(128) NOT NULL, `organization` varchar(128) NOT NULL default '', `email` varchar(128) NOT NULL, `reply-to` varchar(128) NOT NULL default '', `bcc` varchar(128) NOT NULL default '', `signature` text, `html_signature` tinyint(1) NOT NULL default '0', `user_id` int(10) unsigned NOT NULL default '0', `changed` datetime NOT NULL default '1000-01-01 00:00:00', PRIMARY KEY (`identity_id`), KEY `user_identities_index` (`user_id`,`del`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=479 ; -- -------------------------------------------------------- -- -- Structure de la table `messages` -- CREATE TABLE IF NOT EXISTS `messages` ( `message_id` int(11) unsigned NOT NULL auto_increment, `del` tinyint(1) NOT NULL default '0', `cache_key` varchar(128) NOT NULL, `created` datetime NOT NULL default '0000-00-00 00:00:00', `idx` int(11) unsigned NOT NULL default '0', `uid` int(11) unsigned NOT NULL default '0', `subject` varchar(255) NOT NULL, `from` varchar(255) NOT NULL, `to` varchar(255) NOT NULL, `cc` varchar(255) NOT NULL, `date` datetime NOT NULL default '0000-00-00 00:00:00', `size` int(11) unsigned NOT NULL default '0', `headers` text NOT NULL, `body` longtext, `user_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`message_id`), KEY `cache_key` (`cache_key`), KEY `created_index` (`created`), KEY `index_index` (`user_id`,`cache_key`,`idx`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Structure de la table `session` -- CREATE TABLE IF NOT EXISTS `session` ( `sess_id` varchar(40) NOT NULL, `created` datetime NOT NULL default '0000-00-00 00:00:00', `changed` datetime NOT NULL default '0000-00-00 00:00:00', `ip` varchar(15) NOT NULL, `vars` mediumtext NOT NULL, PRIMARY KEY (`sess_id`), KEY `changed_index` (`changed`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Structure de la table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `user_id` int(10) unsigned NOT NULL auto_increment, `username` varchar(128) NOT NULL, `mail_host` varchar(128) NOT NULL, `alias` varchar(128) NOT NULL, `created` datetime NOT NULL default '0000-00-00 00:00:00', `last_login` datetime default NULL, `language` varchar(5) default NULL, `preferences` text NOT NULL, PRIMARY KEY (`user_id`), KEY `username_index` (`username`), KEY `alias_index` (`alias`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=440 ; -- -- Contraintes pour les tables exportées -- -- -- Contraintes pour la table `cache` -- ALTER TABLE `cache` ADD CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Contraintes pour la table `contactgroupmembers` -- ALTER TABLE `contactgroupmembers` ADD CONSTRAINT `contactgroup_id_fk_contactgroups` FOREIGN KEY (`contactgroup_id`) REFERENCES `contactgroups` (`contactgroup_id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `contact_id_fk_contacts` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Contraintes pour la table `contactgroups` -- ALTER TABLE `contactgroups` ADD CONSTRAINT `user_id_fk_contactgroups` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Contraintes pour la table `contacts` -- ALTER TABLE `contacts` ADD CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Contraintes pour la table `identities` -- ALTER TABLE `identities` ADD CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Contraintes pour la table `messages` -- ALTER TABLE `messages` ADD CONSTRAINT `user_id_fk_messages` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
comment:3 Changed 3 years ago by alec
#1487080 marked as duplicate of this bug.
comment:4 Changed 2 years ago by alec
- Resolution set to fixed
- Status changed from new to closed
Fixed in [b46edc0f].
Note: See
TracTickets for help on using
tickets.

I think it can happen only in case of session corruption. So, we can prevent from warning, but better would be to find the reason of corruption. Is this warning reproducable? What PHP version? What DB? Make sure session table (and columns) are using UTF8 encoding.