Server Help :: View topic - MGb, are you updating to 2.0.12 right now?

Server Help

Trash Talk - MGb, are you updating to 2.0.12 right now?

Gravitron - Wed Feb 23, 2005 3:38 pm
Post subject: MGb, are you updating to 2.0.12 right now?

Getting

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/minego/public_html/forums/viewtopic.php on line 1139

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/minego/public_html/forums/viewtopic.php on line 1141

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/minego/public_html/forums/viewtopic.php on line 1141

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/minego/public_html/forums/viewtopic.php on line 1143

At http://forums.minegoboom.com/viewtopic.php?t=4083

Solo Ace - Wed Feb 23, 2005 3:46 pm
Post subject:

I've seen those warning somewhere else before, can't remember which thread it was though.
But since it only seems to be in threads with polls, like this one, it might not be much work to fix.

Gravitron - Wed Feb 23, 2005 3:57 pm
Post subject:

Who knows.
From what I gather MGB did a lot of modifications, could be a mess in there to follow what does what.

Off topic, I was wondering, is php-SQL easy to understand from analysing code lines? Like say BASIC is?
I mean, it's not C++ after all.

Looking at phpBB code for an example, you can understand how things work for the most part or on principle.
So like, is it possible to learn from reading code? Or is it harder than it looks?

Solo Ace - Wed Feb 23, 2005 4:28 pm
Post subject:

What do you mean by "php-SQL"?
Actually I can't figure out what you're really asking, so I'll just post my comments on all possible meanings.

The SQL used in php is just the same as regular SQL, and I guess you could just understand it if you know what a database's table is.
PHP is easy, and it's easy to understand by just reading the scripts.

I'm not sure if phpBB is well designed, their "code" looks awful and I think it's pretty hard to figure out what's actually happing everywhere.

For both PHP and SQL you could learn from reading the "code".

Mine GO BOOM - Thu Feb 24, 2005 1:14 am
Post subject:

Gravitron wrote:

Looking at phpBB code for an example, you can understand how things work for the most part or on principle. So like, is it possible to learn from reading code? Or is it harder than it looks?

Its how I hack out everything I do. I have a good understanding of programming in general, and have done work with Perl before. Use that knowledge to throw up some code, and hope it works. As to the error, I think its occurring because of the changes done to the voting scripts before, but when its reading it, its reading the ending date all screwed up, thus throwing up errors. Only occurs when the voting has an end date.

As for you learning to do your own modifications, it isn't hard. Take a look at others do (phpbbhacks.com is good) and learn from it. If you are attempting to add your own extra SQL calls or modifying the tables, I'd recommend learning a bit more about SQL online and making sure you keep good backups.

Gravitron - Thu Feb 24, 2005 7:25 am
Post subject:

Well, so far phpmyadmin makes editing SQL seem like an easy task.

And yes, I meant to writing php scripts which manipulate a SQL database.

Night_Fox - Thu Feb 24, 2005 7:34 am
Post subject:

Dont you have cpanel that automatically updates phpbb2?

Smong - Thu Feb 24, 2005 7:50 am
Post subject:

I couldn't access this site for about 10 minutes, about 30min ago (look at the timestamp on this post).

Solo Ace - Thu Feb 24, 2005 8:11 am
Post subject:

Automatically updating would probaby overwrite the mods implemented here.
That, and more issues would make it more work to keep the forums running.

I couldn't reach it either, heh.

Night_Fox - Thu Feb 24, 2005 8:34 am
Post subject:

Okay

Gravitron - Thu Feb 24, 2005 10:52 am
Post subject:

Like Solo said
Also, the cpanel is no good unless you installed the phpBB using it, otherwise, it does not recognize it.
And it always assign a DB name and username and password by itself to it...rather insecure ones at that.

Night_Fox - Thu Feb 24, 2005 12:00 pm
Post subject:

I have no troubles with it tho.
I understand what you both said