Hi.

I get this error message, when I try to import from ODS or Excel:

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /test/batch?id=20&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'test.sheetnode' doesn't exist: DELETE FROM {sheetnode} WHERE (vid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 5 ) in _sheetnode_save() (line 1106 of /var/www/test/sites/all/modules/sheetnode/sheetnode.module).

PHPExcel library PHPExcel 1.7.8, 2012-10-12
Drupal 7.22

Any thougths?

Thanks.

Comments

infojunkie’s picture

infojunkie
Location Vancouver
CreditAttribution: infojunkie commented

Looks like the module is not properly installed. Can you verify if the {sheetnode} table is in your database?

swati.karande’s picture

swati.karande CreditAttribution: swati.karande commented

Hi,
I tried to replicate this error on my local instance and I am able to import excel file but not ODS type.
I am getting another type of error for ODS file.
So it looks like there is a problem in module installation.

grn’s picture

grn CreditAttribution: grn commented

Hi!

Thanks for the hints.

Only these two tables were present.
sheetnode_template
sheetnode_view

First I installed the beta and then I installed the development version. I think this mix did not work out.

So I needed to disable the module, uninstall it, and then install the module again. Now the import seems to work, but I only get blank nodes - the same happens when I create a new sheet node. Is there something I am missing here? I used to work with this module in Drupal 6.

infojunkie’s picture

infojunkie
Location Vancouver
CreditAttribution: infojunkie commented

@grn, you probably need to reinstall the socialcalc code from Github.

grn’s picture

grn CreditAttribution: grn commented
Status: Active » Closed (fixed)

@infojunkie: Thanks you are right. Sorry for the trouble.

At least I hope this troubleshooting exercise will help others :-)

Thanks again.

ilioscipriani’s picture

ilioscipriani CreditAttribution: ilioscipriani commented
Issue summary: View changes

hi to al, i know thi is an old trade, but i wonderind the same error i got this tring to import both xls or ods file:

Si è verificato un errore HTTP in AJAX. Codice HTTP di risposta: 500 Di seguito le informazioni di debug. Percorso: /preventivi/?q=batch&id=26&op=do StatusText: Service unavailable (with message) ResponseText: Exception: Serialization of 'SimpleXMLElement' is not allowed in serialize() (linea 110 di /var/www/html/preventivi/sites/all/modules/sheetnode/modules/sheetnode_phpexcel/sheetnode_phpexcel.import.inc).

i got version 1.7.9 of PHPexcel
reinstall social calc and sheetnode, i tring a clean install in a new drupal, i reinstalled all the code of every tring, checked tables on database seems ok.

any help is very appreciated