| Author |
 Topic  |
|
|
Hermes
Junior Member
Croatia
113 Posts |
 Posted - 09 April 2007 : 10:07:22
|
I have problem with one Mod, but since it is probably related with MySql I post this here.
Snitz version 3.4.06
On my test forum I have mysql 4.0, Server: localhost via TCP/IP. I implemented
Front page news Mod. Everything works fine.
But when I implemented it on my live forum, mysql 5.0, Server: localhost via UNIX socket, when I set up news, it does not show them on default page. When I turning in front page news he show me this screen:
http://img341.imageshack.us/img341/9433/mysqlprobvg0.jpg
but nothing happens on default page.
On both forums files are the same.
Now I have looking for the problem in search: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. But nothing of the given suggestions works.
I do not think that it has something to do with read/write problem, since I have lots of other mod implemented, and forums works great.
I tried with check installation update, but not helping.
Option 16387 is default in 06 version.
Access is phpmyadmin. SERVER_SOFTWARE Microsoft-IIS/5.0
This Mod would be very useful to me, and if anybody has some idea, I would appreciate it.
The Mod download link http://www.snitzbitz.com/mods/details.asp?Version=All&mid=47
MOD Version: 1.60
|
ASP Snitz Forum Upute za instalaciju
http://www.kairos.com.hr http://www.hermetizam.com Forum
not so newbie any more :) |
Edited by - Davio on 09 April 2007 10:31:04 |
|
|
kolucoms6
Average Member
845 Posts |
Posted - 09 April 2007 : 10:40:01
|
Even same happened with me whereas I am using MDB.
It happened with me when I replaced my original admin_newspost with Daveo's admin_newspost.asp.
Try replacing yr old admin_newspost.asp
No hard feeling please , Daveo. |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Hermes
Junior Member
Croatia
113 Posts |
Posted - 09 April 2007 : 11:34:53
|
@kulukoms6
I tried already with all default files. It won’t work.
quote:
Originally posted by ruirib
I'd say you need to find out the line that's causing the error, so that you then may find why that is happening.
Unfortunately I am total newbie with asp syntax, so I would not know from where to start.
The peculiar think is that it’s working with mysql 4.0 on test forum.
|
ASP Snitz Forum Upute za instalaciju
http://www.kairos.com.hr http://www.hermetizam.com Forum
not so newbie any more :) |
Edited by - Hermes on 10 April 2007 05:48:02 |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 April 2007 : 11:58:15
|
| The error may have to do with differences from MysQL 5.0 to 4.x or even with the way you setup the mod. That's wht it's important to know what line is causing the error. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Hermes
Junior Member
Croatia
113 Posts |
Posted - 09 April 2007 : 13:18:11
|
quote:
Originally posted by modifichicci
try changing the name of tables in file to upper case:
my_conn.execute ( "INSERT INTO " & strTablePrefix & "news (n_text,n_date,member_id) VALUES ('" & fVariable & "','"&nDate&"',1)")
my_conn.execute ( "INSERT INTO " & strTablePrefix & "NEWS (n_text,n_date,member_id) VALUES ('" & fVariable & "','"&nDate&"',1)")
Yeap!!! That was it!!!
And of course it’s Unix, and he is case sensitive.
I changed all occurrences of news into NEWS, News_Config into NEWS_CONFIG, and member_id into MEMBER_ID.
All is working well now. Thanks for support.
If you ever going to come in Zagreb, I’m buying you a drink.
|
ASP Snitz Forum Upute za instalaciju
http://www.kairos.com.hr http://www.hermetizam.com Forum
not so newbie any more :) |
|
|
|
kolucoms6
Average Member
845 Posts |
Posted - 09 April 2007 : 13:19:44
|
| I liked the end image ;) |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
daveo
New Member
97 Posts |
Posted - 09 April 2007 : 17:17:29
|
quote:
Originally posted by kolucoms6
Even same happened with me whereas I am using MDB.
It happened with me when I replaced my original admin_newspost with Daveo's admin_newspost.asp.
Try replacing yr old admin_newspost.asp
No hard feeling please , Daveo.
No hard feelings - I just ran it. That is one of the challenges of UNIX versus Windoz. Unix DBs are case sensitive. I have been working with Eternal Supports version and debugging it, and I keep running into SQL Server issues. |
http://copdforum.portalone.us/ |
|
|
|
Hermes
Junior Member
Croatia
113 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Hermes
Junior Member
Croatia
113 Posts |
|
| |
Topic |
|
Topic Locked
