Simple Invoices - Forum

Is SVN version the same as this Beta? (5 feb 2009, 14:50h)?

I've just tried to make a PDF invoice: The bottom 2.5cm (more or less) is missing. In the HTML version, all info is available.
In the 20080630-stable version, the PDF output is correct.

(Using my own invoicing template; checked into SVN).

I no longer can see the euro symbol in the generated PDF.

Marcel

hey marcel

thanks for the svn commits!

re PDF
- re euro - can you try and remove this line near the bottom of sql_queries.php
$pipeline->data_filters[] = new DataFilterUTF8(""); and retest
- re bottom 2.5cm - have a look in the pdfThis function in sql_queries.php - and also have a read up on the html2pdf docs - refer tufat.com - also library/pdf/samples
-- i'll add the bottom/pdf issue into the todo.txt fiel and check it out

cheers

justin

Commenting out the above-mentioned line didn't change a thing.

It gets even weirder: In some invoices I see the euro sign, in others I don't. Where is the currency sign coming from?

I noticed that the automatic payment invoices did show the euro sign, and the normal ones, do not. I looked at the invoice preferences, and for some reason, the euro symbol was corrupted in one layout, while the other was okay.
I just did an export from the stable database, and imported that in the SVN one, so ity should be the same.

Nevertheless, this problem is solved (re-entered the euro sign).

The footer issue I will look into later.

Marcel

hey marcel

re euro symbol
- just thinking about this - in the svn/beta2 release we've started to use a new mysql/pdo connection string to handle utf8 better
- the resulting problem is that any euro symbols/non-latin symbols that were entered in the previous versions may not work 100%

try editing the invoice preference and reenter the euro symbol then retest and let me know if all ok

if not ok try removing the mysql_attr_init_commands from the connection string in sql_queries.php and retest

let me know how you go

- might have to make a big not for upgrading users that non-latin characters may not be happy and might need to change the connection string
- i might make an option in system preferences for this


cheers

justin

Manually re-entering the euro symbol did solve the euro issue, thanks

Marcel

In the 'description' under each item - it's not saving what is typed or printing what is in that 'description' box. Am I missing something ?
Can you help please ?
Jason

Hello
and download the version of Simple Invoices 2009 1 veta2 but I can not install it gives me an error
and also not in the package file SIMPLEINVOICESDATA.sql nor the config.php file.

CAN SOMEONE HELP ME?

hey spy2

re .sql
- refer: http://www.simpleinvoices.org/blog#whats_new
- if this is a new database restore at least the 2 .sql files ./database/MySQL/Structure.sql and Essentials.sql
- if you want the sample data restore SampleData.sql as well

re config.php
- we're now using ./config/config.ini

once the 2009.1 release is out of beta the docs will be updated to include all teh updated info

let us know how you go

cheers

justin

@marcel
- thanks for the update
- i'll include a big note to users upgrading re non-latin characters and make it easy to edit teh config to change the sql connection string

cheers

justin

@Jason

are you using english as the language or something else?

cheers

justin

yes Justin - English as the main language
en-gb in config.ini

jason

Sorry I posted this on the blog: but it's probably better here. So here goes.

Just installed under Ubuntu 8.10 server using pdo_mysql PDO Driver for MySQL, client library version 5.0.67

Found the following.

1 { smarty errors regarding smarty being declared twice.

commented require_once out from docs.php then moved the include init above the $smarty = new statement.

$t = isset($_GET['t'])?$_GET['t']:null; $p = isset($_GET['p'])?$_GET['p']:null;

# require_once(”./library/smarty/Smarty.class.php”); include(”./include/init.php”); $smarty = new Smarty(); $smarty ? compile_dir = ”./tmp/cache/”; }

2 { In Ubuntu 8.10 all maintenance screens that are supposed to list invoices, billers, customers etc show the animated graphic with “processing please wait…” but never return the list of items. This is true with SampleData.sql loaded or not. }

3 {

When clicking add biller. It throws an error about not being able to access a resource in

./templates/default/biller/add.tpl (this path doesn't exist)

./templates/default/billers/add.tpl (this however does)

A quick fix was to ln -sf billers biller and the error disappears (don't know if this borks anything.

}

4 { when adding a new invoice when seeing

“Processing invoice, you will be redirected Quick View of this invoice”

Instead of the quick view of a webpage a file download dialog pops up with index.php as the file to download. }

I am accessing the Ubuntu 8.10 server with a Ubuntu 8.04 box using Firefox 3.0.5.

Looks like point 2 may be related to this error in Firefox's error console.

Error: junk after document element
Source File: http://ubuntu/si/index.php?module=invoices&view=xml
Line: 2, Column: 1
Source Code:
Fatal error: Call to a member function bindValue() on a non-object in /srv/simpleinvoices/include/sql_queries.php on line 91

@ JasonM
- thanks for the update - i'll look into this

@jmcd
- thanks for the info

re 1
- thanks i've done as you suggested but really need to move docs.php into the normal Simple Invoices code - hopefully i can get rid of all these individual files php file - cause to many problems

re 2

just found the issue- your php error reporting is probably on E_ALL or something - to 'hide' these errors and make everythign all happy add this code into the bottom of ./config/define.php

#####################
/* Error reporting */
#####################
#
#error_reporting(E_STRICT);
#error_reporting(E_ALL);
#error_reporting(E_WARNING);
error_reporting(E_ERROR);
#error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);
#error_reporting(0);

this only hides the issue - i've got to do the real fix - will do to the todo list

re 3 -adding biller - is this from the yellow box section on the home page? - if so i've just committed the fix for this

re 4- the error reporting thing may make this ok - let me know how you go

Cheers

Justin

Justin ....

nothing yet still gives me the same error that this

Fatal error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND' in C: \ AppServ \ www \ seam \ include \ sql_queries.php on line 49

any solution?

change line 49 from

$pdoAdapter.':host='.$config->database->params->host.'; dbname='.$config->database->params->dbname, $config->database->params->username, $config->database->params->password, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8", PDO::MYSQL_ATTR_INIT_COMMAND=>"SET CHARACTER SET utf8;")

to

$pdoAdapter.':host='.$config->database->params->host.'; dbname='.$config->database->params->dbname, $config->database->params->username, $config->database->params->password

and retest

let us know how you go

cheers

justin

ok ya lo hice pero ahora me muestra este error teniendo todo configurado con el nombre de host, pass, y usuario mira el error
==========================================
Simple Invoices database connection problem
===========================================
Could not connect to the Simple Invoices database

For information on how to fix this pease refer to the following database error:
--> could not find driver

If this is an Access denied error please make sure that the database.params setting in config/config.ini are correct
===========================================

despues de cambiar la linea 46 del archivo sql_queries.php me da este error y no puedo instalar nada todavia

==========================================
Simple Invoices database connection problem
===========================================
Could not connect to the Simple Invoices database

For information on how to fix this pease refer to the following database error:
--> could not find driver

If this is an Access denied error please make sure that the database.params setting in config/config.ini are correct
===========================================

hey spy2

can you check if you have php pdo installed

refer phpinfo.php in the simpleinvoices dir - if it doesnt say anything about pdo and pdo_mysql then you need to install PDO for your PHP

let us know how you go

also what version of php are you on?

cheers

justin

ok is ready

thks

no worries

cheers

justin

@Jason
- just looking at this now
- what browser are you using?

is anyone else having the problem where the stuff entered in the line item description isnt saving

Cheers

Justin

1) The description field is scrunched up on left side under quanity ( 50 px x 50 px ) or so.
2) When editing an invoice the add new row button does not.
3) When adding a new invoice and using the dropdown menu for products the price of the product is not input.

Also a request.

Would it be possible to add an entry to the product dropdown menu (like a blank) so that I could use the description to input one-of products.

George

I tried to install the new beta but i got this error:


Fatal error: Uncaught exception 'Zend_Log_Exception' with message '"./tmp/log/si.log" cannot be opened with mode "a"' in /home/xxxx/public_html/SI/library/ZendFramework/1.7.2/Zend/Log/Writer/Stream.php:66 Stack trace: #0 /home/xxxx/public_html/SI/include/init.php(39): Zend_Log_Writer_Stream->__construct('./tmp/log/si.lo...') #1 /home/xxxx/public_html/SI/index.php(22): require_once('/home/xxxx/...') #2 {main} thrown in /home/xxxx/public_html/SI/library/ZendFramework/1.7.2/Zend/Log/Writer/Stream.php on line 66

Nice work Justin

Just installed simple-invoices-20091-beta-2 an it works a treat... It even took my custom template without any issues.

Just one thing though - how do I get rid of the red block around the submenu items?

I've had a look through css/menu_header.css but I got a bit confused :o)

Thanks

Chris

@ chris
- thanks
-re red block
-- refer: /extensions/tab_menu/templates/default/css/tab.css and look for the .active class

@don
- thanks for spotting this
- just chmod -Rv 777 the ./tmp dir and shoudl be ok - thats just make it writeable
- i've justed added a nice error message for this - so this should help others resolve this issue in the next release onwards

cheers

justin

@George
- for 2 & 3 javascript needs to be enabled in your browser - which is probably is unless your using the no-script firefox extension
- let me know if you have javascript on

re 1
- description is supposed to appear in the text box under the invoice line item as in this image
img src="http://simpleinvoices.googlegroups.com/web/description.png?gda=R_DvVUEAAAC_3sPLZancAiVK0Lh6glgAhT3HddaZZkiEVCJlYMA9smcxprMwON_2TutVO_XCMTVTCT_pCLcFTwcI3Sro5jAzlXFeCn-cdYleF-vtiGpWAA' />
- let me know if description appears different in your browser

re request
- if you mean be ablel to add a new product while in the new/edit invoice page - this is a good idea and i'll add it to our list http://www.simpleinvoices.org/roadmap/dreamtime

cheers

justin

Thanks Justin - sorted it

no worries chris

cheers

justin

Hi Justin

When adding or editing NEW invoices in Beta 2, the {$invoiceItem.description} is not saved. The box appears OK just like the image above.

If you create a new invoice and add a description then save it - the quickview will display it, but not the print preview.

If you edit a new invoice and add a description - it won't display in quick or print view.

If you edit and save an invoice imported from a previous version - it's OK in all views.

If I import existing invoices, the description is OK.

Bit of a problem, as I always add details for the client.

Thanks

Chris

@JUSTIN...

- what browser are you using?
SAFARI

- what I've found is that it's saving anything I type into the Item/Description box first up, but if I want to edit... it doesn't save the new or changed data. If I go to edit/add to the description, after the first save - it doesn't save the new changes.

...seems the previous post has the same problem.

Feed back would be really appreciated.

jason

thanks jason and chris for detailing this issues!

im pretty sure i've got it sorted now - so should be fine in 2009.1 beta 3 - which will be out in a few weeks

cheers

justin

Justin,

Yes java script is enabled, & what is in your is nothing like mine.

This is in the edit window, and the description is under the quanity field only ir measures about 50px x 50 px.

This is on database that hase been converted from 20080511.

Thanks
George

Justin,

Followup to last post

This happens in both Firefox 3.0.6 and IE 6 & 7, I can zip the page and send it to you if that would help.

Also there are some errors flagged in ie Line2 char 1 Syntax error Code 0.

When I have run into this in the past there are ususlly duplicate named items in the HTML, css & javascript. Which messed up IE's Javascript processor.

thanks george

is it possible for you to install firebug in firefox and then check the firebug console when try to add a new line item or select a product

let us know how you go - will be interesting to see what the errors are

cheers

justin

I've been using "simpleinvoices_20080926" for months and there is no problem. After you release "simpleinvoices.2009.1.beta2" i wanted to try it in another hosting as a brand new. I dont wanted to get risk and now i am tetsing it.

Now i wonder how can i export all my costumers/billers/invoices/payments/etc and import them into new one? For a while i want to use the both script. Not completely upgrade the old one or move to new one. So i dont need the upgrading information. I need to dublicate the data.

Tnx.

don_camillo

In SI, if you go to options - backup database, this will give you your whole database in an SQL file which can then be imported into your new database via phpmyadmin

Hope this helps

Chris

Justin,

No errors in fire bug. The firefox error console shows the following 3 errors

Warning: Unknown property 'zoom'. Declaration dropped.
Source File: http://localhost/p3/BillingBeta/include/jquery/cluetip/jquery.cluetip.css
Line: 294

Warning: Error in parsing value for property 'opacity'. Declaration dropped.
Source File: http://localhost/p3/BillingBeta/templates/default/css/tabs.css
Line: 6

Warning: Expected end of value for property but found '5px'. Error in parsing value for property 'border'. Declaration dropped.
Source File: http://localhost/p3/BillingBeta/templates/default/css/tabs.css
Line: 70

Hope this helps.