Dolibarr: 3.9.0-beta Printing error

tssmn · November 24, 2015, 8:26pm

This page lists printing jobs found for available printers.

Dolibarr heeft een technische fout gedetecteerd.
Dit is informatie die kan helpen bij het diagnostiseren:
Datum: 20151124201057
Dolibarr: 3.9.0-beta
Niveau van de functionaliteiten: 0
PHP: 5.3.0
Server: Apache/2.2.11 (Win32) PHP/5.3.0
OS: Windows NT LUW4U 6.2 build 9200 ((null)) i586
UserAgent: Mozilla/5.0 (Windows NT 6.2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36

Gezochte Url: /dolibarr/printing/index.php
Referer: http://localhost/dolibarr/printing/index.php
Standaard menuverwerker: eldy_menu.php

Database Type Manager: mysqli
Query laatste foute toegang tot database: SELECT token FROM llx_oauth_token WHERE service=‘Google’
Verkregen laatste toegangscode met fundamenteel fout: DB_ERROR_NOSUCHTABLE
Informatie over de laatste fundamentele toegang fout: Table ‘dolibarr.llx_oauth_token’ doesn’t exist

Fatal error: Call to a member function fetch_array() on a non-object in H:\dolibarr\www\dolibarr\htdocs\core\db\mysqli.class.php on line 307

Help?

tssmn · November 25, 2015, 10:37pm

Solved some things true update-files but now a message shows up:

- No active module to print document

and

- Token not found in db, are you sure you stored it?
No default printer defined

Modules active:
- Oauth
- Direct Printing
- ZenFusion OAuth

frederic34 · February 3, 2016, 9:23am

Hello

For Google Cloud Print in 3.9 you need
- Oauth
- Direct Printing

Fred

tssmn · February 5, 2016, 1:10pm

Please see my previous post:

Modules active:
- Oauth
- Direct Printing
- ZenFusion OAuth

It’s not working somehow… still recieve the message:
- No active module to print document

frederic34 · February 6, 2016, 7:59pm

Hello
Did you configure oauth (ZenFusion OAuth is not needed)
take a look in the french forum, I explain how to configure oauth with google.
Did you configure printers with google cloud print? https://www.google.com/cloudprint/#printers

Fred

frederic34 · February 6, 2016, 10:20pm

Hello
Example of oauth config:

Fred

frederic34 · February 6, 2016, 10:22pm

Fred

frederic34 · February 6, 2016, 10:24pm

Printer List:

Fred

frederic34 · February 6, 2016, 10:27pm

Big brother is watching me:

Fred

tssmn · February 7, 2016, 8:05pm

I don’t know exactly what i’m doing wrong…
I’ve followed the stepts exactly in your posts.

This is the message for now: (Sorry most written in Dutch)

This module adds a Print button to send documents directly to a printer (without opening document into an application) with various module.

Dolibarr heeft een technische fout gedetecteerd.
You use an experimental or develop level of features, so please do NOT report any bugs, except if problem is confirmed moving option MAIN_FEATURES_LEVEL back to 0.

Dit is informatie die kan helpen bij het diagnostiseren:
Datum: 20160207195455
Dolibarr: 3.9.0-rc
Niveau van de functionaliteiten: 2
PHP: 5.5.22
Server: Apache
OS: Linux cp20.c-panel-server.com 2.6.32-604.30.3.lve1.3.63.el6.x86_64 #1 SMP Sun Sep 27 06:34:10 EDT 2015 x86_64
UserAgent: Mozilla/5.0 (Windows NT 6.2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.103 Safari/537.36

Gezochte Url: /ok80-de71-pc7423-hn704/printing/admin/printing.php?mode=config
Referer: http://www.luw4u.nl/ok80-de71-pc7423-hn704/printing/admin/printing.php?mode=config
Standaard menuverwerker: eldy_menu.php

Database Type Manager: mysqli
Query laatste foute toegang tot database: SELECT token FROM doli_oauth_token WHERE service=‘Google’
Verkregen laatste toegangscode met fundamenteel fout: DB_ERROR_NOSUCHTABLE
Informatie over de laatste fundamentele toegang fout: Table ‘luwunl_doli1.doli_oauth_token’ doesn’t exist

Fatal error: Call to a member function fetch_array() on a non-object in ***********core/db/mysqli.class.php on line 307

tssmn · February 7, 2016, 8:09pm

Installed:
- Dolibarr 3.9rc
- Oauth
- Directprinting

Printer shows up at Google Cloudprinting and is already configured.
Brother printer supports Cloudprinting.

frederic34 · February 7, 2016, 11:02pm

Hello
Seem missing table:

CREATE TABLE IF NOT EXISTS llx_oauth_state (rowid int(11) NOT NULL AUTO_INCREMENT, service varchar(36), state varchar(128), fk_user int(11), fk_adherent int(11), entity int(11), PRIMARY KEY (rowid)) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS llx_oauth_token (rowid int(11) NOT NULL AUTO_INCREMENT, service varchar(36), token text, fk_user int(11), fk_adherent int(11), entity int(11), PRIMARY KEY (rowid)) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Fred

tssmn · February 8, 2016, 3:54pm

Still the message:

frederic34 · February 8, 2016, 4:00pm

Hello
Try to create doli_auth_token table in place of llx_oauth_token

Fred

tssmn · February 8, 2016, 4:31pm

Changed the last code… no error for now.
But the next setting don’t work…

To request en new token, the link ends at my own (error 404)webpage outside Dolibarr. So no token to request.
Click here to request/renew access and receive a new token to save

From GitHub the file getgoogleoauthcallback.php uploaded, the link works…

And again:

frederic34 · February 8, 2016, 4:49pm

Hello
Can you create the table doli_oauth_state:
CREATE TABLE IF NOT EXISTS doli_oauth_state (rowid int(11) NOT NULL AUTO_INCREMENT, service varchar(36), state varchar(128), fk_user int(11), fk_adherent int(11), entity int(11), PRIMARY KEY (rowid)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

Fred

frederic34 · February 8, 2016, 5:24pm

Hello
The file getgoogleoauthcallback.php has been renamed in google_oauthcallback.php and it is why it’s no longer working
you can use getgoogleoauthcallback.php and set this address in google api

Fred

tssmn · February 8, 2016, 7:05pm

I looked at the code:

~\core\modules\oauth\google_oauthcallback.php (48): $currentUri = $uriFactory->createFromAbsolute($urlwithroot.'/core/modules/oauth/getgoogleoauthcallback.php');

and changed getgoogleoauthcallback.php to google_oauthcallback.php

Finaly it works Thanks for your patience, help and time !!

djouonang · April 11, 2016, 4:36pm

Salut Fred,

Je suis coincé avec le probleme d’autorisé le token pour aficher les imprimantes. J’ai deja lu un thread ou tu as donner la solution mais je nai pas bien compris stp je voulais demander si tu peut expliquer d’avantage. Je suis anglophone mon francais n’est pas tres bon.

frederic34 · April 11, 2016, 6:18pm

Hello
Your server is linux or win?
Some people have problems with curl and windows because ssl certificates are not up to date.
Fred