| Author |
 Topic  |
|
SnapperL
Starting Member
24 Posts |
 Posted - 01 August 2006 : 05:03:21
|
Well I'm getting a very interesting error (using mysql version)
here is the conn string in config.asp
the name of my sql db is 'SnapperL'
http://www.discussthat.com/forum/sitemap.asp
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.27-max-log]Table 'SnapperL.FORUM_forum' doesn't exist
/forum/sitemap.asp, line 108
< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
Edited by - SnapperL on 01 August 2006 05:34:07 |
 |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
SnapperL
Starting Member
24 Posts |
Posted - 01 August 2006 : 08:07:27
|
Hey Podge and modifichicci and everyone else!
table prefix in config.asp is:
<%
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
strFilterTablePrefix = "FORUM_" 'used for BADWORDS and NAMEFILTER tables
%>
So from the tableprefix and the error I am surmizing(sp?) that it can't find the table name "forum" am i right in assuming that this is what it means? If this is the case....any ideas? 
and i'm using a windows hosting option....?< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
Edited by - SnapperL on 01 August 2006 09:05:02 |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
SnapperL
Starting Member
24 Posts |
Posted - 02 August 2006 : 03:07:01
|
changing forum to FORUM fixed the sql problem, there is an xsl/xml problem:
http://www.discussthat.com/forum/sitemap.xml.asp< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
SnapperL
Starting Member
24 Posts |
Posted - 02 August 2006 : 08:55:53
|
Well hey hey, its working now! Thanks again for your help
< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
Edited by - SnapperL on 02 August 2006 12:52:07 |
|
|
|
SnapperL
Starting Member
24 Posts |
Posted - 02 August 2006 : 12:54:22
|
i'm getting an invalid time error from google....
quote:
Invalid date (Line 2) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 3) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 4) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 6) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 11) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 14) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 15) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 19) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 20) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
Invalid date (Line 29) An invalid date was found. Please see How do I specify time? for more information before resubmitting. More
This is happening on every instance of the time
any thoughts?< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
Edited by - SnapperL on 02 August 2006 12:58:20 |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
SnapperL
Starting Member
24 Posts |
Posted - 02 August 2006 : 14:46:06
|
| ahhh makes sense... ill try that< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
borge
Junior Member
Norway
185 Posts |
Posted - 22 January 2007 : 18:07:25
|
| |
borge |
|
|
|
grazman
Junior Member
USA
193 Posts |
Posted - 24 January 2007 : 16:41:30
|
| A very interesting script. Has there been any thought given to topics that have multiple pages? Do we need to have each page listed in the site map?< |
SQLTeam.com - For SQL Server Developers and Administrators |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 24 January 2007 : 19:06:11
|
Podge, thank you so much for this, it saves me a lot of work.
On broadband with IE7 I can generate a sitemap with all of my 10,000 plus topics in about 10 seconds then just File > Save as > and upload. It validates within minutes. I'll just do it every few days.
Thank you!
< |
Switch the order of your title tags |
|
|
|
Topic |
|
Google Sitemaps Mini-mod (Beta)
