July 2005 - support - lists.drupal.org

[drupal-support] Database error, maybe from a bug
by Abalieno 21 Jul '05

21 Jul '05

My site kept sending a DB errors for a few hours. I had to use phpmyadmin to check the tabs and repair them. Now everything seems working. The error that was produced is: Duplicate entry '227855' for key 1 query: INSERT INTO accesslog (title, path, url, hostname, uid, timestamp) values('World of Warcraft - Repository', 'node/421', '', '213.67.34.175', 0, 1121956981) in /home/.lanza/abalieno/cesspit.net/drupal/includes/database.mysql.inc on line 66. Instead this is the error that produced the disaster: Got error 127 from storage engine query: INSERT INTO accesslog (title, path, url, hostname, uid, timestamp) values('general gaming news', 'aggregator/categories/7', 'http://www.google.ca/search?hl=en&q=alex%2Binfinium+capital&meta=cr%3Dcount…', '70.25.22.115', 0, 1121956966) in /home/.lanza/abalieno/cesspit.net/drupal/includes/database.mysql.inc on line 66. Hiccup of the DB or bug in Drupal? I'm using a 4.6.0 running okay for a few months. -HRose / Abalieno

1 0

[drupal-support] Upgrading database from 4.5.4 to 4.6.2 (was Psychophobia)
by sunblockster＠gmail.com 21 Jul '05

21 Jul '05

First, a *huge* thank you to everyone on the list who has helped us resurrect our site after the hack, especially to Gerhard. It's always amazing to experience the support of the OSS community. I think we are almost there. I upgraded from 4.3.x to 4.4 to 4.5.4 without a hitch--an exhilirating feeling. I just ran the 4.6.2 upgrade.php on the database, choosing the first update after the 4.5 release. Everything went well until here: > 2005-03-21 > > user error: Duplicate entry '0-11' for key 1 > query: ALTER TABLE term_node ADD PRIMARY KEY (tid,nid) in /path/to/ > file/www/drupal462/includes/database.mysql.inc on line 66. > > ALTER TABLE {term_node} ADD PRIMARY KEY (tid,nid) > FAILED > > 2005-04-14 > > 2005-05-06 > > 2005-05-07 > > ALTER TABLE {locales_source} CHANGE location location varchar(255) > NOT NULL default '' > OK > Any ideas why this failed, and how to fix it? Many thanks. On Jul 20, 2005, at 5:04 PM, Gerhard Killesreiter wrote: > > > On Wed, 20 Jul 2005 sunblockster(a)gmail.com wrote: > > > >> A 4.4 tarball would be great if you think that would do the trick. >> How do we work that? >> >> > > http://tfp1.physik.uni-freiburg.de/~killes/drupal-4.4.tar.gz > > You need to pay attention for the start of the update from 4.5 to > 4.6. You > need to select the first after the 4.5 release. > > Cheers, > Gerhard > >

3 7

[drupal-support] using img_assist
by D_C 21 Jul '05

21 Jul '05

hi - when using img_assist to include an image on a blog entry, the image thumbnail links back to just the image. is there a way to get it to link to the body of the blog entry? i tried putting the img_assist tag inside an HREF but it over-rides the link. <A href='node/52' > [img_assist|fid=15|alt=Jetro interview] </a> can someone point me to a list of parameters or docs on the img_assist module? the developers site is just an announce. /dc

1 0

[drupal-support] Restoring hacked site -- (Psychophobia backdoor)
by Dan Baum 20 Jul '05

20 Jul '05

Our drupal system was recently hacked with the PsychoPhobia Backdoor exploit and I am looking for suggestions on the best way to get back up and secure. Our hosting company gave us this from the web logs: [16/Jul/2005:18:37:15 -0400] "POST /xmlrpc.php HTTP/1.1" 200 25 "-" "-" There is apparently a known vulnerability in XML-RPC that made this possible. The sysadmin gave us the following instructions: >> The archived files will be made available for you to download some time later today. However, you would not want to upload the files back to the server, as they are suspect, UNLESS you have done a full security audit on the files to ensure their integrity. Better yet, is to restore the site from known "pristine" backups that were not on the web server, such as local backups on your local computer. ... "XML-RPC for PHP XML-RPC for PHP 1.1.1" is listed as not vulnerable. We could not find a version number on the xmlrpc PHP module on your site, but it would appear that it is not version 1.1.1. When you have access to your site again, you will need to use the non-vulnerable version of XML-RPC when restoring the site. >> Two questions for the helpful folks on this list: a) Our version of Drupal was about 1.5 years old. Will the new version prevent this sort of thing? Do we need to install a different version of PHP, or will the files that need updating be in the Drupal package? b) In any case we will take the "opportunity" to install the latest version of Drupal. We do not have a "pristine" local backup. Is there a painless and *secure* way to transfer the content from the old site (remember, our version is about 1.5 years old)? Can we be sure we're not transferring any infected stuff if we copy the data from the old mysql database? Many thanks, -David

10 17

Re: [drupal-support] Adding meta tags
by Kobus Myburgh 20 Jul '05

20 Jul '05

Kaspar, The article you mentioned is based on HTML 4.01 specs it seems. According to the w3c.org website, XHTML's meta tag does close with the /> and not the >. Thanks for attempting though! Anyone else have any ideas about this? TIA, Kobus >>> ITBJDM(a)puknet.puk.ac.za 7/20/2005 1:13:37 PM >>> On second though, Kaspar, that means Drupal is also wrong (if the article you mention is correct). All the other meta tags are like that, even those added by Drupal itself. Is there someone who can confirm this? If so, I will file a bug report. Regards, Kobus >>> kaspark(a)gmail.com 7/20/2005 1:08:12 PM >>> Probably this is just an error in IE, not being strict. According to below mentioned article, the meta tags should not close with /> but >. http://searchenginewatch.com/webmasters/article.php/2167931 brgds Kaspar On 7/20/05, Kobus Myburgh <ITBJDM(a)puknet.puk.ac.za> wrote: > > Hi, > > For some strange reason, when I view the source of my page in IE, it > displays the meta tag description, but in FireFox it doesn't. I have added > the description meta tag line in the theme itself, and I have cleared the > cache in IE and FireFox, but somehow the two versions differ. > > This causes the trouble that a prominent South African search engine keeps > refusing my site as they don't see my description tag either. > > Here is the line in my theme: > > <meta name="description" content="Property Professionals - Home of the > Potchefstroom, Parys and Klerksdorp branches of Huizemark." /> > > This is in the head section of the document. > > It shows up in IE but not in FireFox. What could be the problem? I need to > get my site submitted to that site engine... :( > > Is there a better place to add these details as in the theme file itself? > > Thanks in advance, > > Kobus > > > -- > [ Drupal support list | http://lists.drupal.org/ ] > -- Vh Kaspar Skype: hrkaspar Mobil 51901212 Tlf. privat 36302630 arb. 43204128 -- [ Drupal support list | http://lists.drupal.org/ ]

1 0

Re: [drupal-support] Adding meta tags
by Kobus Myburgh 20 Jul '05

20 Jul '05

On second though, Kaspar, that means Drupal is also wrong (if the article you mention is correct). All the other meta tags are like that, even those added by Drupal itself. Is there someone who can confirm this? If so, I will file a bug report. Regards, Kobus >>> kaspark(a)gmail.com 7/20/2005 1:08:12 PM >>> Probably this is just an error in IE, not being strict. According to below mentioned article, the meta tags should not close with /> but >. http://searchenginewatch.com/webmasters/article.php/2167931 brgds Kaspar On 7/20/05, Kobus Myburgh <ITBJDM(a)puknet.puk.ac.za> wrote: > > Hi, > > For some strange reason, when I view the source of my page in IE, it > displays the meta tag description, but in FireFox it doesn't. I have added > the description meta tag line in the theme itself, and I have cleared the > cache in IE and FireFox, but somehow the two versions differ. > > This causes the trouble that a prominent South African search engine keeps > refusing my site as they don't see my description tag either. > > Here is the line in my theme: > > <meta name="description" content="Property Professionals - Home of the > Potchefstroom, Parys and Klerksdorp branches of Huizemark." /> > > This is in the head section of the document. > > It shows up in IE but not in FireFox. What could be the problem? I need to > get my site submitted to that site engine... :( > > Is there a better place to add these details as in the theme file itself? > > Thanks in advance, > > Kobus > > > -- > [ Drupal support list | http://lists.drupal.org/ ] > -- Vh Kaspar Skype: hrkaspar Mobil 51901212 Tlf. privat 36302630 arb. 43204128

1 0

Re: [drupal-support] Adding meta tags
by Kobus Myburgh 20 Jul '05

20 Jul '05

Thanks a lot, Kaspar. I will change my theme appropriately, and fix the issue. Hopefully that works. Regards, Kobus >>> kaspark(a)gmail.com 7/20/2005 1:08:12 PM >>> Probably this is just an error in IE, not being strict. According to below mentioned article, the meta tags should not close with /> but >. http://searchenginewatch.com/webmasters/article.php/2167931 brgds Kaspar On 7/20/05, Kobus Myburgh <ITBJDM(a)puknet.puk.ac.za> wrote: > > Hi, > > For some strange reason, when I view the source of my page in IE, it > displays the meta tag description, but in FireFox it doesn't. I have added > the description meta tag line in the theme itself, and I have cleared the > cache in IE and FireFox, but somehow the two versions differ. > > This causes the trouble that a prominent South African search engine keeps > refusing my site as they don't see my description tag either. > > Here is the line in my theme: > > <meta name="description" content="Property Professionals - Home of the > Potchefstroom, Parys and Klerksdorp branches of Huizemark." /> > > This is in the head section of the document. > > It shows up in IE but not in FireFox. What could be the problem? I need to > get my site submitted to that site engine... :( > > Is there a better place to add these details as in the theme file itself? > > Thanks in advance, > > Kobus > > > -- > [ Drupal support list | http://lists.drupal.org/ ] > -- Vh Kaspar Skype: hrkaspar Mobil 51901212 Tlf. privat 36302630 arb. 43204128

1 0

[drupal-support] Adding meta tags
by Kobus Myburgh 20 Jul '05

20 Jul '05

Hi, For some strange reason, when I view the source of my page in IE, it displays the meta tag description, but in FireFox it doesn't. I have added the description meta tag line in the theme itself, and I have cleared the cache in IE and FireFox, but somehow the two versions differ. This causes the trouble that a prominent South African search engine keeps refusing my site as they don't see my description tag either. Here is the line in my theme: <meta name="description" content="Property Professionals - Home of the Potchefstroom, Parys and Klerksdorp branches of Huizemark." /> This is in the head section of the document. It shows up in IE but not in FireFox. What could be the problem? I need to get my site submitted to that site engine... :( Is there a better place to add these details as in the theme file itself? Thanks in advance, Kobus

2 1

[drupal-support] user registration
by Rahul Benegal 20 Jul '05

20 Jul '05

Hi. I would like to do the following on my drupal site: 1. Add a field (location) to user registration. 2. Have a mail sent to me that a user has registered (its a low volume site, so not an issue). Pls give me some ideas how i can do the same. -- rahul benegal http://kalki.benegal.org

2 1

Re: [drupal-support] user registration
by Kobus Myburgh 20 Jul '05

20 Jul '05

Hi, 1. Install profile.module if it is not installed yet, and define the "Location" field in the profile fields. 2. A quick hack may be something like this: Search for user_mail() in the module, and where you find the line where it sends the welcome mail to the user, just add a user_mail() command with your own e-mail address hardcoded. I am sure there are more elegant ways to do this, but this is the quickest dirty-fix there is. Regards, Kobus >>> rahulbenegal(a)gmail.com 7/20/2005 7:19:01 AM >>> Hi. I would like to do the following on my drupal site: 1. Add a field (location) to user registration. 2. Have a mail sent to me that a user has registered (its a low volume site, so not an issue). Pls give me some ideas how i can do the same. -- rahul benegal http://kalki.benegal.org -- [ Drupal support list | http://lists.drupal.org/ ]

1 0