I wish to use drupal and erp to manage invoice but I have some problems and I don't know what to do with this error message. It's seem to be a database problem.
My config:

Version de Apache:
Apache/2.0.59 (Win32)

Version de PHP:
5.2.0

Extensions chargées:
bcmath, calendar, com_dotnet, ctype, session, filter, ftp, hash, iconv, json, odbc, pcre, Reflection, date, libxml, standard, tokenizer, zlib, SimpleXML, dom, SPL, wddx, xml, xmlreader, xmlwriter, apache2handler, mbstring, gd, mysql, mysqli, PDO, pdo_sqlite, SQLite

Version de MySQL:
5.0.27-community-nt

* warning: Invalid argument supplied for foreach() in C:\wamp\www\factures\modules\node.module on line 374.
* warning: implode() [function.implode]: Bad arguments. in C:\wamp\www\factures\modules\node.module on line 378.
* user warning: 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 '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in C:\wamp\www\factures\includes\database.mysql.inc on line 121.
* user warning: Unknown column 's.sid' in 'field list' query: SELECT n.title, s.sid FROM node n LEFT JOIN erp_store s ON n.nid = s.nid WHERE type = 'erp_store' in C:\wamp\www\factures\includes\database.mysql.inc on line 121.
* warning: Invalid argument supplied for foreach() in C:\wamp\www\factures\includes\form.inc on line 671.

Comments

oadaeh’s picture

I've got those errors, also. They're not a result of a database problem, though. Based on what I've been able to locate in searching the Internet, I'm guessing those errors (or at least some of them) are because you and I are using PHP 5. It would be nice to see if anyone is getting those errors w/PHP 4, so we can confirm if PHP 5 is the problem or not.

singularo’s picture

Assigned: Unassigned » singularo
Status: Active » Closed (won't fix)

I think you just need to create a "store" so that the invoice can be assigned to it. Having said that, I'd suggest moving up to the 5.x branch later this week, as development will stop on 4.7 very soon, and 5.x is a lot easier to install already.

Your software looks fine, I develop on Linux with these versions:

PHP 5.2.1 (cli) (built: May 22 2007 19:03:23)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies

Server version: Apache/2.2.3
Server built: Jan 15 2007 18:49:49

But one of my staff uses WAMP, and i certainly have in the past with no problems