direct invoice & sales order problem

Can you see something spurious in your error_log for the specific operation periods?

/Joe

Hello David,
Strange.
Maybe you can run a System Diagnostics (Setup tab) and either copy this into a text file or take a picture of it and send it to us.
You see our email in the Anouncement Forum.

/Joe

Thanks David,
I have sent it to Janusz for further investigation. If you haven't tried the $go_debug=1 in config.php you might try it. So if you already have backed your client, you could try the direct invoice again to see if anything show up with $go_debug flag set to 1.

/Joe

Hello again,
Janusz is busy at present and asked me to give this advise to you:

"We have seen these before. They were related to broken session variables. I would advice
check save_path for session variables, restart www server, and clear borwser
cache."

So please try this, David. And let us know if it helps.

/Joe

The session_save_path is set in your php.ini file. Check where this folder is located by searching for this session_save_path.
Then check the session file inside this folder for broken sessions. This is not easy, but maybe you can see if there seems to be broken sessions at the end.

/Joe

Hi Joe,

I emailed janusz as after I did a fresh install with 2.2.3 (new db, db user) the direct invoice function still gave the same errors and produced 3 ghost sales orders.

If I do sales order->delivery->invoice there's no problem at all, so something is up with the direct sales invoice function in the code.

It seems to be seeing the location as blank for some reason, but I'm sure you will figure it out-if i was any good at php i would try and figure it out myself .

Cheers,

David

Hi wbaileynzl,

I have been emailing Janusz with any details I can find and I think it's been tracked down to an sql setup file glitch.

I have used en_GB-general.sql to setup my companies, so I don't know if the fix below applies yet.

Janusz recommends this fix:

I think we have finally found the problem. Probably you haven't tax_types
table created in your database.

We had a bug in en_US-new.sql which caused error during installation when
example data option was not selected.  Unfortunately because of another issue in Create/Update companies page company with broken database was created and the error message is only displayed by the moment.

You can repair your database structure by removing invalid sales_order, sales_order_details, refs records and recreating tax_types table with:

CREATE TABLE `0_tax_types` (
   `id` int(11) NOT NULL auto_increment,
   `rate` double NOT NULL default '0',
   `sales_gl_code` varchar(11) NOT NULL default '',
   `purchasing_gl_code` varchar(11) NOT NULL default '',
   `name` varchar(60) NOT NULL default '',
   `inactive` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`id`)
) ENGINE=InnoDB;

I think you log in to mysql with root password, choose the database for FA then run the above command, I need more advice before I attempt it.

Hi,

I have the same problem like londondaveuk. I also deleted the default POS. So I just recreated default POS with cash sales and updated user records, but it didn't solve the problem.

I looked into the code and it seems that 1) clicking on "Place Invoice" results in three calls to sales_order_entry.php (so each call creates sales order),  and 2) the value of $src->trans_type in function write() in cart_class.inc looks "strange".

Cheers,
St