Closed (fixed)
Project:
XML sitemap
Version:
6.x-1.x-dev
Component:
xmlsitemap_user
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
23 Dec 2008 at 18:55 UTC
Updated:
7 Jan 2009 at 19:30 UTC
The Last updated: December 23, 2008 - 12:18 gives only a blank (white) website after uploading with ftp.
I use Drupal 6.8 and the earlier version of xmlsitemap is running fine.
any ideas whats wrong?
Best regards from germans, holger
---
IT-News from http://w3projekt.com
Comments
Comment #1
avpadernoIt means that something is wrong, but the report doesn't say anything about the cause.
It would help to know what Drupal, or PHP reports in the log; usually they report an error message that helps to understand what is wrong.
Comment #2
avpadernoI am using the most recent code, and I don't get any blank pages. I also created a node, deleted it, added a comment without to see any errors.
Comment #3
avpadernoComment #4
eagereyes commentedI'm having the same problem, error message:
Parse error: syntax error, unexpected ')', expecting ';' in /[...]/sites/all/modules/xmlsitemap/xmlsitemap.module on line 123
This is the offending line, and it's a rather obvious missing opening parenthesis. Perhaps this line is only triggered on some systems (haven't looked at the surrounding code):
Comment #5
avpadernoThe parenthesis needs to be removed, but I have already committed the code with the fix. I will force a commit, and see if that changes something.
Comment #6
philbar commentedI'm having the same issue.
Comment #7
avpadernoThe download files are recreated, for a development snapshot, at midnoon and midnight GMT, so if the problem was still present you should wait to get the updated files.
I am trying to resolve an issue with the editor I was using, and that caused me problems when I was committing the files directly from it. Maybe it will take a little, as I still have to understand what it did wrong, and what it didn't really commit.
Comment #8
avpadernoComment #9
philbar commentedThe new Build appears to be working fine for me.
Comment #10
avpadernoComment #11
holger commentedHere are the Errors:
* user warning: Table '14453m2708_1.xmlsitemap_user' doesn't exist query: SHOW COLUMNS FROM xmlsitemap_user LIKE 'pid' in /web/1/000/014/453/10569/htdocs/drupal/includes/database.mysqli.inc on line 351.
* user warning: Table '14453m2708_1.xmlsitemap_user_role' doesn't exist query: SHOW COLUMNS FROM xmlsitemap_user_role LIKE 'pid' in /web/1/000/014/453/10569/htdocs/drupal/includes/database.mysqli.inc on line 351.
* user warning: Can't DROP 'PRIMARY'; check that column/key exists query: ALTER TABLE xmlsitemap_file DROP PRIMARY KEY in /web/1/000/014/453/10569/htdocs/drupal/includes/database.mysql-common.inc on line 386.
* 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: ALTER TABLE xmlsitemap_file CHANGE fid `fid` INT unsigned NOT NULL DEFAULT 0, ADD in /web/1/000/014/453/10569/htdocs/drupal/includes/database.mysql-common.inc on line 520.
* user warning: Can't DROP 'PRIMARY'; check that column/key exists query: ALTER TABLE xmlsitemap DROP PRIMARY KEY in /web/1/000/014/453/10569/htdocs/drupal/includes/database.mysql-common.inc on line 386.
* user warning: Table '14453m2708_1.xmlsitemap_node' doesn't exist query: SHOW COLUMNS FROM xmlsitemap_node LIKE 'pid' in /web/1/000/014/453/10569/htdocs/drupal/includes/database.mysqli.inc on line 351.
* user warning: Table '14453m2708_1.xmlsitemap_term' doesn't exist query: SHOW COLUMNS FROM xmlsitemap_term LIKE 'pid' in /web/1/000/014/453/10569/htdocs/drupal/includes/database.mysqli.inc on line 351.
Drupal is now showing but the sitemap is without content!
I also tried to delete the tables in he database and reinstall the module, but same errors!
What can i do now?
Comment #12
avpadernoComment #13
avpaderno@holger: Are you installing XML Sitemap, or are you updating it?
Comment #14
stoltoguzzi commentedhat the same problem using the new version.
I deinstalled the modul and reinstalled it.
But now I do not have the fields to add the search-engines anymore!
What can I do now?
And the sitemap.xml link shows "no element found"
Comment #15
avpadernoThe update function has been changed, and now it creates the tables if they don't exist. I am not sure in which cases the module is being updated, and it doesn't have its tables installed (if it is being updated, the installation function has already created them).
In this way, the module tables are being created during the installation, and in the update (when they don't exist).
I am changing the status to fixed, as the code has been committed to CVS.