Google listing error

[dex]

I've obviously had the bots through because I'm now listed on google. Which is great but this is what you see in googles results.

Database Error (http://www.buylow.co.nz/) ... list' Error Number : 1054 Date : Apr 03, 2006, 20:19:18 Script : http://www.buylow.co.nz/index.php Referrer : Not referred IP Address : 66.249.72.51.


But, if you click on this link, it takes you to my home page, no worries at all.

I had SEO links turned on, and have since turned them off but no joy. Can anyone help? Should I contact google?

Tim

[wterpilo]

Hi dex
I have the same. What I did is:
- delete index.php
- in .htaccess add 'Index main.php'

I think that in index.php redirection is not too good so google can't index it. I've already posted it to Peter and did it on my site. So I'm waiting now for effects:)

[edwin]

The solution I found on this error is to create a index.php for your frontpage. Don't use the current index.php. Google can't deal with it.

After you changed your frontpage to index.php, it takes 3 to 5 days (next crawler vistit) and it's fixed.

Edwin.

[trochta]

If you don't wish to create a new page you can redirect to your main.php using the following code, replacing the current code in index.php:


<?

header("HTTP/1.1 301 Moved Permanently");
header("Location: http://www.sitename.com/main.php");
exit();

?>

[phbock]

There is an old saying (from the 1930´s I think) that goes "If you want it slow use LAMP (LinuxApacheMySQLPHP)". I think we can resolve the two issues (Google and speed) with the same trick:

- Open your browser
- go to www.yourdomain.eu (http://www.yourdomain.eu)
- Right click the page, then "view sourcecode"
- delete the line that says "current marketplace time is...."
- save as "index.html"
- upload to your webserver root
- tell .htaccess to look for index.html first

This is going to speed up the first page load to your site (which is usually the one your users will run away if speed doesn´t satisfy them), AND this is going to resolve the Google issue. Only drawbacks: no more marketplace time on first load (afterwards yes) and personalised "hello user".

cheers
Phillip

[Peter]

This issue is extremely interesting. We are currently investigating the cause.

Regards,
Peter

[delta]

I looked through google and noticed that every site using V3 including Ilance marketplace v3.ilance.ca have this problem. Google has listed all of them with db errors.

If one creates a pure html index page as suggested by Phbock won't we loose our multilingual function? I am not an expert in this but again Ilance has to put this as top priority.

[trochta]

Peter,

Not sure if this helps point you in the direction of the problem, but...

If you find an older ilance powered site, such as 2.8, then go to a metatag analyzer, review that site, and you will see that it was being read correctly during that version.

[phbock]

Hi Peter,


I find it extremely important to have this issue resolved. Any progress here?

My current situation is that I changed the index page to a static page, and now I get listed correctly by Google, but these guys will never (be able to) make a deep crawl if the content showing up on the site is just db errors.

Please consider this a priority, as it takes very long to create page rank and climb up the SERPs. I wouldnßt want to spend my money on google-adwords longer than absolutely necessary, and I think not being able to become listed by google is just a killer.

One more thing that is happening to me, strangely, that I think is related to this is that google understands my content as being from [url removed], which is an ILance site.
So as long as I had the ILance php code online, and google was just pumping out db-errors as the results of the searches, google on their cache page also said that the crawled domain was [url removed] On the SERPs however, google claimed to talk about my page.
Now last week I suddenly got a google PageRank of 3 (!!!) overnight, with so far just 3 inbound links. Magic!!! But in the meantime I figured that there is a way of "cloaking" PageRank results by redirecting to a page that has PR.
This is what happended to my site. It appears that google somehow goed to my site, and thinks itself (reads the content from) edelegate, assigns me the page rank, but never reads the content of my site.

So I would really URGE you to stay on top of this Peter. Thx.

And to all those that have a google listing just showing db errors, check the cash and find out whether the domain name given there is wrong. Or, if the googlebar shows you have PR already check your site here: http://www.database-search.com/sys/pre-check.php They will tell you if your PR on the googlebar is real, or wether there is cloaking in the game, and let us know if this happens and to what site this links.

cheers
Phillip

[phbock]

Peter,

this is what happens with the cache of google for my site (I loaded through main.php):

MySQL error: 1054
Application: main.php
Unknown column 'phrase.text_' in 'field list'
Query: SELECT phrase.varname, phrase.text_ AS text, groups.groupname AS phrasegroupname FROM v3_language_phrases AS phrase, v3_language_phrasegroups AS groups, v3_language AS lang WHERE groups.groupname = 'wantads' AND groups.id = phrase.phrasegroupid AND lang.languageid = ''

, and this is what happens in the cache of google for http://www.buylow.co.nz/ (http://www.buylow.co.nz/) (the exact same apart from domain name and IP address also for our polish friend http://www.aukcjapracy.com/ (http://www.aukcjapracy.com/) ) (Those two load through index.php).

There appears to be a problem with the database.
You may retry your action by clicking the Refresh (http://www.buylow.co.nz/#) button in your web browser.

E-Mail was forwarded to our Staff, whom you can contact if the problem continues.

We apologise for any inconvenience this may have caused.

SELECT phrase.varname, phrase.text_ AS text,
groups.groupname AS phrasegroupname
FROM v3_language_phrases AS phrase,
v3_language_phrasegroups AS groups,
v3_language AS lang
WHERE groups.groupname = 'main'
AND groups.id = phrase.phrasegroupid
AND lang.languageid = ''
MySQL Error : Unknown column 'phrase.text_' in 'field list'
Error Number : 1054
Date : Apr 20, 2006, 12:23:46
Script : http://www.buylow.co.nz/index.php
Referrer : Not referred
IP Address : 66.249.72.66

Hope this helps a little bit. Do you have any ideas in the meantime?

thx
Phillip

[trochta]

Phillip and all,

Once your site is up and running, replace your site's initial index.php with the php code I placed above or create your own "home" page. This will allow google to follow the proper page and post the proper page.

There is no issue with the DB.

[delta]

Phillip and all,

Once your site is up and running, replace your site's initial index.php with the php code I placed above or create your own "home" page. This will allow google to follow the proper page and post the proper page.

There is no issue with the DB.

Trochta. Thanks but did this redirection really work for you? I ask this since many of the sites having this problem are using the main.php as entry not index.php. Thanks again for the tip though.

[phbock]

Phillip and all,


Once your site is up and running, replace your site's initial index.php with the php code I placed above or create your own "home" page. This will allow google to follow the proper page and post the proper page.

There is no issue with the DB.
The comment "There is an issue with the db" is part of the errormessage that google cites in the cache.

cheers
Phillip

[trochta]

The error message is a generic message and is being output while attemting to find a table in the database that does not exist.

I changed my index.php and it just updated correctly in google today.

[delta]

The error message is a generic message and is being output while attemting to find a table in the database that does not exist.

I changed my index.php and it just updated correctly in google today.

Hi Trochta, did you redirect to main.php like using the code you posted or did you change the index.php entirely. I just want to understand exactly what you did that worked.

[trochta]

The above code is my entire index.php

[trochta]

Please note that now Google search return displays:

My Site Title
Site's wonderful discription is here.
http://www.sitename.com/main.php

See that it is posting the main.php page rather than the index.php.

[phbock]

trochta,


just two questions to your solution:
- would your solution add a dns request to normal users (given that in the redirect you give the complete domain name)?
- my site in the google cache has been YOUR site for a time. Now I converted the main.php into a static page (not dynamic). Then google understood me correctly, but with the next deep crawl google then fetched the second level of pages that are all still dynamic, and I am back to db errors for all the second level pages, and google now thinks me in the cache to be v3.ilance.ca. You are still happy with your solution?

I might suggest one thing: Your site is listed well in part because you have the highest page rank of all of us, while alll the others (including v3.ilance.ca) have less page rank. This, combined with the fact that our sites are all VERY similar (especially with all the heavy css content that is equal for all of us), might convince the googlebot to see us as dublicate content. Jsut an idea. What do you think?

[trochta]

Thanks for bringing this topic back up...

The system's duplicate content issue will be hard to change until we begin populating our system with users, content, etc. This is no different that anyone purchasing a vbulletin system with zero content or limited content.

As for the database error... My recent posting on google, for the main.php page only, displays the error. I have a separate home page that displays as it should. So, until we get to the bottom of what all is happening I suggest using an Index page outside of the ilance system.