| Author |
 Topic  |
|
campinmom03
Junior Member
USA
190 Posts |
 Posted - 06 April 2008 : 19:23:07
|
ruirib,
None that I can see. I was told after the conversion, that my.asp page was not working properly, and that the reason why it is not working is because my tables were not done in uppercase.
Honestly, I don't know what is causing it.
It maybe something else causing it to not work, I don't know...I'm still learning. I think we can rule out the table theory? Its got me. It was working perfectly before the switch... but this happens to many who convert right?
When this was done Bill and I fixed whatever was needed that we knew was caused by our own oversights of our own work and what not. All and all I don't think we did anything wrong, and for the most part the site does work allright. Well, IMO. 
If you have a minute though and you would like to look at it, you can check it out with my test account. Maybe you can see something that I don't.
myfamilyforumz.com
user: snitz
pass: snitz2000
|
Have a great day!
Terry |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 April 2008 : 04:59:42
|
campingmom,
If the problem was with the table names, you would have SQL errors (something like 'cannot find Table TableName'). If you don't have SQL errors, then your problem lies elsewhere and it SURELY is not due to table name case.
Upgrading to MySQL can be a tricky process and the table structure must be properly created (keys, identity fields, indexes, default values and such). Likely your current problems are still a result of the upgrade process, but I can't be sure. If the modded version you are using supports MySQL, you should be able to create the proper table structure in an empty DB and then just import the table data, but I don't know the version you are using (and upgrading is just one of the reasons I really don't like most existing modded versions, and I'm not even considering quality support).
To ask for help, you should provide precise error messages. That's the only way to get proper, focused help. Otherwise it's a wild goose chase, as you are probably finding out now.
As a final note, unfortunately our board is a Snitz support forum. As we don't know the code of the several modded versions lying around, we don't support it. I don't mind you posting here for help, but you should be aware that support for your forum version should be given by the modded version creator. I believe someone else is providing that support now, since the departure of the original creator. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 07 April 2008 : 06:14:51
|
quote:
originally posted by ruirib
To ask for help, you should provide precise error messages. That's the only way to get proper, focused help. Otherwise it's a wild goose chase, as you are probably finding out now.
If there are error messages I do give as much detail as I possibly can. But there was none to give.
quote:
As a final note, unfortunately our board is a Snitz support forum. As we don't know the code of the several modded versions lying around, we don't support it. I don't mind you posting here for help, but you should be aware that support for your forum version should be given by the modded version creator. I believe someone else is providing that support now, since the departure of the original creator.
I always go there first for help... and have always been grateful for any help I have recieved here. I've never expected anyone here to support that version. Yes, I ask for help and usually I'm told to try this or that. Which I do most times myself (unless it is a paid project). I don't just come here to expect it to be done for me.
I'm so sorry I posted.
|
Have a great day!
Terry |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 April 2008 : 11:28:51
|
Well, I didn't mean that you should not post here, you're welcome to post... but I do feel frustrated about the amount of help we cannot provide over those mods. In fact, your current situation shows how much these mods are not dependable, since they really rely on an individual's effort, and as far as they are willing to go, one day they'll go away and who will take care of the people, such as you, who installed their mods and now need their support? Who?
You can see the level of support you now get, with some moron assigning blame for the problems you're now facing on table name case, when you simply have no SQL syntax errors, which would be the only ones you could get for table case issues with MySQL, if they were at all possible!
Admitting that your code was running correctly before the upgrade, I will assign blame to your current issues on the upgrade. I would advise you to do it all over again, running the setup.asp file to create all the database tables, with a new, blank DB. Of course, I'm admitting that the setup.asp does create all the tables needed. If it does not, then you will need a manual migration process, but that would, IMHO, show how unreliable show a forum code is.
Coding is fun, but when you release a mod to be used by someone, that is serious business, because people will be relying on you and you can't let them down... as it seems to me that you were now, with your ServerHacker modded code. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 08 April 2008 : 07:06:25
|
quote:
Well, I didn't mean that you should not post here, you're welcome to post... but I do feel frustrated about the amount of help we cannot provide over those mods. In fact, your current situation shows how much these mods are not dependable, since they really rely on an individual's effort, and as far as they are willing to go, one day they'll go away and who will take care of the people, such as you, who installed their mods and now need their support? Who?
Thank you for clarifying if I can post or not. I've enjoyed being a member here. I'm frustrated too. Your right. No one will and I don't blame snitz for not wanting to provide support for others work.
quote:
Admitting that your code was running correctly before the upgrade, I will assign blame to your current issues on the upgrade. I would advise you to do it all over again, running the setup.asp file to create all the database tables, with a new, blank DB. Of course, I'm admitting that the setup.asp does create all the tables needed. If it does not, then you will need a manual migration process, but that would, IMHO, show how unreliable show a forum code is.
I will try this. If it does not create the tables needed I will not do another migration as I trust your opinion on the unreliablility of the code. I have already wasted enough of my time and money on it. If necessary I have a working copy that was on an access db. That would have to do until I can figure something else out.
quote:
Coding is fun, but when you release a mod to be used by someone, that is serious business, because people will be relying on you and you can't let them down... as it seems to me that you were now, with your ServerHacker modded code.
Yes it is fun. Your right in your point. Although, I think its fair to say, this doesn't just apply to just the Serverhacker modded code. There are many mods out there that have been left to the wayside leaving many in the same position. |
Have a great day!
Terry |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 April 2008 : 07:35:50
|
Terry,
It's not a matter of us not wanting to provide support, it's just that we don't know the code done by others. We can't really support what we don't know and most people here will do the same - and that is the right thing to do, since I would simply not risk giving advice that would cause you to lose data or to get your forum not working properly for some time.
We are fortunate to have many people contributing here and we have a wealth of skills from those contributors, so we just should let those who really know what they are talking about to provide that help. Personally, I will always post about something I know and have experience with, otherwise I just leave it to someone else to offer advice. Each user's forum is invaluable to that user, so my view is that we should value it as we value our own!
You're right about the mods, that's why I always refrain from adding something from someone who has not a track record of coding reliability, at the very least!
Well, try creating the tables using my advice and let me know how it goes. I won't promise, but if some stuff is missing, I can try to have a look at the Access DB and see if I can help. Surely indexes will be missing and that I can't help with, cause I don't know the code and the queries it runs on the database, but the defaults and such I may be able to get it right. No promises, though . |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
|
|
Topic Locked
