 | Re: What MOD is this? |  |
 Posted: 11/30/2006 9:01 AM |
 |
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
 |
|
|
|
Joined: Oct 29, 2006
Local time: 5:59 PM
Location: Klang, Malaysia
|
|
|
|
|
 |
What problem is this?
Could not update forum views.
DEBUG MODE
SQL Error : 1054 Unknown column 'forum_views' in 'field list'
UPDATE phpbb_forums SET forum_views = forum_views + 1 WHERE forum_id = 73
Line : 338
File : viewforum.php
Im using on my subsilver templates |
|
|
|
|
| Back to Top |
|
|
| Re: What MOD is this? | |
| Posted: 11/30/2006 1:49 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:59 PM
Location: St Pete, FL
|
|
|
|
|
|
| masteranu84 wrote:
|
|
SQL Error : 1054 Unknown column 'forum_views' in 'field list'
|
This error message gives you a very good clue of what the problem can be. Your code tried to run an SQL query against your database but didn't find the forum_views field in the phpbb_forums table. So your first thought should be is was there a database update for the MOD I just installed? Obviously there was. So you would read the author's notes to try to determine what to do next...
If you had used EM, it would have run the following for you or told you that there was a problem with it. So why aren't you using EM to install these MODs? You're making this much harder on yourself than it needs to be...
| Code:
|
#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_forums ADD forum_views MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL;
|
 |
|
|
|
|
| Back to Top |
|
|
| Re: What MOD is this? | |
| Posted: 12/01/2006 12:57 AM |
|
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 5:59 PM
Location: Klang, Malaysia
|
|
|
|
|
|
| Nightrider wrote:
|
| masteranu84 wrote:
|
|
SQL Error : 1054 Unknown column 'forum_views' in 'field list'
|
This error message gives you a very good clue of what the problem can be. Your code tried to run an SQL query against your database but didn't find the forum_views field in the phpbb_forums table. So your first thought should be is was there a database update for the MOD I just installed? Obviously there was. So you would read the author's notes to try to determine what to do next...
If you had used EM, it would have run the following for you or told you that there was a problem with it. So why aren't you using EM to install these MODs? You're making this much harder on yourself than it needs to be...
| Code:
|
#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_forums ADD forum_views MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL;
|
|
Ok. I don't understand this at all ...sorry.. can step by step tell me what should i need to do on my 1st step? Can u show some print screen ? |
|
|
|
|
| Back to Top |
|
|
| Re: What MOD is this? | |
| Posted: 12/01/2006 1:48 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:59 PM
Location: St Pete, FL
|
|
|
|
|
|
If you would start using EM, you wouldn't have to worry so much about stuff like this:
phpMyAdmin - Manually Applying SQL Code
The following is how you apply your SQL code manually to your phpMyAdmin database. You can get into your database through your CPanel by clicking on phpMyAdmin. Follow the following instructions:
I'm sure that every host is different. I will tell you how I run my queries manually and hopefully it will be close to what you have available to you. The following may or may not be similar to what you have...
Log into your domain Control Panel and find the database icons. You should be able to find the phpMyAdmin icon. Click on it...
Hopefully that will log you into your phpAdmin panel. You may need to provide a username and password...
In the phpMyAdmin panel, click on the Databases hyperlink...
Hopefully that should take you where you can select your database. You may only have one. Select your database hyperlink...
That should open up the display of all the tables in your database. Ignore them. Somewhere on the page, you should see something similar to this:
Click on the SQL tab to display something like the following where you can copy all of the SQL commands in at once:
Click on the Go button and the queries will be run. If all goes well, you will be told that the commands were executed successfully. Otherwise you will see a screen that tells you which command failed. If the columns that you are trying to add already exist, a duplicate will not be added...
Hopefully my instructions above are close to what you would see on your domain. If not, perhaps you could provide some screenshots of what you have available and we can figure out what you need to do. I use Gadwin Printscreen to create the screenshots and www.ImageShack.us to host them so they can be posted here...
 |
|
|
|
|
| Back to Top |
|
|
| Re: What MOD is this? | |
| Posted: 12/03/2006 2:28 AM |
|
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 5:59 PM
Location: Klang, Malaysia
|
|
|
|
|
|
Issit it will automatic install after i import which file i want to install ?  |
|
|
|
|
| Back to Top |
|
|
| Re: What MOD is this? | |
| Posted: 12/05/2006 10:22 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:59 PM
Location: St Pete, FL
|
|
|
|
|
|
Yes, EM will apply the MOD code to your phpBB files. It definitely simplifies the install process and avoids human error...
 |
|
|
|
|
| Back to Top |
|
|
| Re: What MOD is this? | |
| Posted: 12/06/2006 11:07 AM |
|
|
|
|
|
| Citation |
| Posts |
487 |
| Word Cnt. |
35,729 |
| BDay |
Oct 3 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Oct 29, 2006
Local time: 5:59 PM
Location: Klang, Malaysia
|
|
|
|
|
|
| Nightrider wrote:
|
Yes, EM will apply the MOD code to your phpBB files. It definitely simplifies the install process and avoids human error...
|
I dunno use it.... Issit 1st step need to copy the MOD zip file into my FTP ? After it ..click the query and puting the installation COD and click GO? Do you can print screen step by step ? What should i need to do 1st ?
1.1st step
2.?
3.?
4.?
5.?
6.?
.?
.?
? |
|
|
|
|
| Back to Top |
|
|
| Re: What MOD is this? | |
| Posted: 12/06/2006 3:21 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:59 PM
Location: St Pete, FL
|
|
|
|
|
|
You would extract the MOD files and folders before uploading the MOD folder to your admin/mods directory. If you haven't already done so, you really should read the following and it should make things a lot more clear for you. Since you can use your Test forum to install the MOD, there really shouldn't be anything to fear from trying to learn how to use EM...
Installing MODs with EM FAQ
If you haven't done so, read this section: Installing MODs with EasyMOD
If you run into any problems during the MOD install, don't hesitate to ask for additional support. Let me know how it goes..
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
