forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: kb1100 on January 29, 2006, 03:10:41 am
-
I was working on my gallery then when I hit refresh it gives me the following mesage comes up and nothing else:
Template error
Failed to find block 'output_buffer'(#(<!-- BEGIN output_buffer -->)(.*?)(<!-- END output_buffer -->)#s) in :
<tr>
<td class="tableb" align="center">
<font size="3"><b>{MESSAGE}</b></font>
<!-- BEGIN file_line -->
<br />
<br />
{FILE_TXT}{FILE} - {LINE_TXT}{LINE}
<!-- END file_line -->
<br /><br />
</td>
</tr>
I cannot get to my gallery at all now only this, I do not know what caused this. Could anyone please help me? Thank you very much for any help.
-
This looks like a theme error. Did you customize $template_cpg_die in your theme.php? If you did, you need to copy $template_cpg_die from sample/theme.php and include the output_buffer block. If you want that block to be empty, empty out the space between the <!-- BEGIN output_buffer --> and <!-- END output_buffer -->, but do *not* delete those two comments. That should solve your problem.
If you had searched for "template error" or "failed to find block", you would have found a sticky thread on the themes board that describes this error in detail.
-
Ok, thank you if I have a problem again I will search first. But I was using the default theme, I hadnt changed anything. Snork made me a new theme that I had added but I was not using it, and I don't code so I didn't know what had happened. Do you think this is something I would be able to fix?
-
kb1100: Ok. My response covered the most likely case for the information you gave. If it doesn't cover your case, let's continue the support discussion. You are using the classic theme, unmodified? If so, the classic/theme.php is empty, so that would be very weird to have this problem. Have you modified any of the core scripts? Please provide a link to your site. Even if you are stuck right now with that error message, we might be able to look at what it's saying and figure out more details of the problem.
-
Yes, I was using the default theme and I had not modifyed it at all. And I had just been to the page 20 minutes before with it working fine. I would like to keep the url private so I do not want to post it here, if you can help I can email you the link or something if necessary. But I don't know what the link to the site would do seeing every page gives the same error that I posted, its just an all white screen with the text that I posted.
-
Ok. Assuming you're using 1.4.3 (or 1.4.2), the error message you're getting could only come from one place. This line is in the file functions.inc.php (which is in the "include" directory):
template_extract_block($template_cpg_die, 'output_buffer');
If you comment out this line as shown:
// template_extract_block($template_cpg_die, 'output_buffer');you should be able to access your site again.
However, the reason why this line is executed is because your Coppermine site has another error that causes the cpg_die function to be called. But at least you should be able to figure out what the error is.
Ideally, you should uncomment that line afterwards because the output buffer is generally not necessary with the current debug info returned.
The base reason you are getting the "failed to find block" error can only be one of two cases:
(1) you modified themes.inc.php and removed the output_buffer block from $template_cpg_die
(2) you modified your current theme.php and did the same thing
I cannot think of any other way you can get this particular error. If you didn't modify either file, I guess one of those files must be corrupt. Or you are using a hack/mod/add-on/plugin that removes this block somewhere else.
edit: For example, I can reproduce this same error by adding $template_cpg_die to my theme.php, removing the output_buffer block, then trying to access admin.php from a non-admin account.
-
Thank you very much for your help. I did exactly as you told me by adding // in front of that line of code. When I try to go to my gallery now I get the following instead:
Template error
Failed to find block 'log_ecards'(#(<!-- BEGIN log_ecards -->)(.*?)(<!-- END log_ecards -->)#s) in :
<div align="center">
<table cellpadding="0" cellspacing="1">
<tr>
<!-- BEGIN admin_approval -->
<td class="admin_menu" id="admin_menu_anim"><a href="editpics.php?mode=upload_approval" title="{UPL_APP_TITLE}">{UPL_APP_LNK}</a></td>
<!-- END admin_approval -->
<td class="admin_menu"><a href="admin.php" title="{ADMIN_TITLE}">{ADMIN_LNK}</a></td>
<td class="admin_menu"><a href="catmgr.php" title="{CATEGORIES_TITLE}">{CATEGORIES_LNK}</a></td>
<td class="admin_menu"><a href="albmgr.php{CATL}" title="{ALBUMS_TITLE}">{ALBUMS_LNK}</a></td>
<td class="admin_menu"><a href="groupmgr.php" title="{GROUPS_TITLE}">{GROUPS_LNK}</a></td>
<td class="admin_menu"><a href="usermgr.php" title="{USERS_TITLE}">{USERS_LNK}</a></td>
<td class="admin_menu"><a href="banning.php" title="{BAN_TITLE}">{BAN_LNK}</a></td>
<td class="admin_menu"><a href="reviewcom.php" title="{COMMENTS_TITLE}">{COMMENTS_LNK}</a></td>
<td class="admin_menu"><a href="picmgr.php" title="{PICTURES_TITLE}">{PICTURES_LNK}</a></td>
<td class="admin_menu"><a href="searchnew.php" title="{SEARCHNEW_TITLE}">{SEARCHNEW_LNK}</a></td>
<td class="admin_menu"><a href="util.php" title="{UTIL_TITLE}">{UTIL_LNK}</a></td>
<td class="admin_menu"><a href="profile.php?op=edit_profile" title="{MY_PROF_TITLE}">{MY_PROF_LNK}</a></td>
<!-- BEGIN documentation -->
<td class="admin_menu"><a href="{DOCUMENTATION_HREF}" title="{DOCUMENTATION_TITLE}" target="cpg_documentation">{DOCUMENTATION_LNK}</a></td>
<!-- END documentation -->
</tr>
</table>
</div>
I understand logically that you can only come up with those reasons but I honestly did none of the things you came up with. The last thing I did was edit a description of an image, and when I came back I got that error.
-
Could you post the description you entered?
-
The description was deleting what I had before, but I didn't think that would cause this seeing I didn't change any code or anything. That was just in the actual image options.
-
Let's confirm a few more basics about what you have.
- You are running a new install of 1.4.3 with no plugins, no mods, no hacks applied.
- You are set up with the "classic" theme, which you have not modified.
- The new theme from "Snork" is in its own folder in the themes/ directory with no other files anywhere else.
Please confirm these 3 things, and add details you can think of.
The reason this is important is that the 2 errors you received are theme errors, but the "classic" theme has no theme customizations whatsoever, so this is truly a mystery.
A link to your site would help us since we can try to run other files in Coppermine to give us an idea what causes this error. If you want to keep it private, that's OK, but it will take more careful details to figure out what's going on. We like to keep support on the public forums, and we don't want to start receiving links in PMs because I would think that would start a flood of such requests.
-
Yes, I am running 1.4.3, and I haven't installed anything other then Snorks theme. Which was simply putting the folder in the themes folder. Yes, I am using the classic theme and I have not modified it at all. I haven't used Snorks theme nor added any other files any where other then adding images to the albums folder. I don't know what else really to add I am just as mystified as you. I was working on the gallery deleted a description and the next time I came to it I recieved that error. You can instruct me if you need a link or ftp info.
-
First of all, I don't know who Snork is and what theme is his. But I assume it's not named 'classic' and so didn't overwrite that one.
Look in your database, using phpMyAdmin or whatever else you have, in the cpg143_config table for the record with name="theme", i.e.:
SELECT * FROM `cpg143_config` WHERE name='theme'(replacing cpg143_ with whatever prefix you used for the database tables).
If it has a value of "classic", then look in your themes/classic/theme.php and make sure it's blank (except for the header comments).
-
I went to my phpmyadmin Am I looking for theme on the left in that list on the main page? If so its not there. Or are you saying go to the config on that list and look for the theme in there?
-
I'm not sure which page of phpMyAdmin you are talking about. The database is whatever name you picked, the table name is "cpg143_config", then in that table, there are 2 fields: "name" and "value". The record you are looking for has a "name" field of "theme". The "value" of that record is what you want.
Alternatively, in phpMyAdmin, you can click on the SQL tab and put in the SQL command I posted and that should give you the result. Oh, as long as you are in the correct database.
-
Ok, when I put that line in I get this:
Showing rows 0 - 0 (1 total, Query took 0.0004 sec)
SQL-query:
SELECT *
FROM `cpg140_config`
WHERE name = 'theme'
LIMIT 0 , 30
-
Look further down the page... there should be a table that lists the name of the theme. I got the same message when I ran the query.
-
This is the oly other thing on the page beside a print option:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cpg140_config ref PRIMARY PRIMARY 42 const 1 Using where
-
If you type the MySQL statement in the pop-up window, the result will be on the main window (even if the pop-up window doesn't close itself). In either case, on the main window you should see a table with a repeat of the statement you entered which has a table header of either "Showing rows 0 - 0 (1 total, Query took 0.0006 sec)" or "MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 sec)". The empty result message will obviously not show anything else. If you get the first message, there will be another table below the echoed MySQL statement with the results of the query. With only one result, it will be a small table. You'll see column headers of "name" and "value" and the first & only row with "theme" and whatever your theme is set to.
It's interesting that your table prefix is cpg140. Did you originally install a 1.4 beta, before 1.4.2 or 1.4.3 were released as stable releases? Or did you just pick "cpg140" as a generic 1.4 table prefix? The default for 1.4.3 is "cpg143".
-
I posted all that came up when I put that line into the query window which was:
Showing rows 0 - 0 (1 total, Query took 0.0004 sec)
SQL-query:
SELECT *
FROM `cpg140_config`
WHERE name = 'theme'
LIMIT 0 , 30
Here is a link to a screen cap so you can see what I am seeing: http://img489.imageshack.us/my.php?image=phpmyadmin5ux.png
Im not sure on the other question, I thought I had the latest vesion I downloaded it a couple of months ago
-
The first stable release of the 1.4 series was 1.4.2 and was released on November 24th. The latest release is 1.4.3 and was released on December 27th. I think you downloaded the beta version and that might be related to this issue since your theme is set to be "core", not "classic". I'll have to go find a beta release to figure out what the "core" theme is; I haven't heard of it, but I'm a new dev team member so it might have been "before my time".
Looking at your screencap (thanks for posting it), you'll see a small table, just above the text "check all", "uncheck all". This table shows "name = theme", "value = core". As I said above, your theme is set to "core", what I don't recognize. The current default simple theme is "classic". The "classic" theme is dirt-simple as I said, and doesn't include any customizations so the errors mentioned above are not possible with the "classic" theme.
You could try a quick fix of changing that config value in phpMyAdmin to "classic", but I don't think this is a good fix. I think you are going to have lots of other issues due to having an outdated version.
The best thing to do would be to download 1.4.3 using the Downloads link at the top of this page. Then install 1.4.3 in the same folder as an *upgrade* installation, following the directions in the docs (linked at the top of the page as well) for upgrading. This will overwrite the files with pristine versions of the latest release. Your database will be updated, and you won't lose any of your files or settings if you follow the upgrade instructions. I assume the upgrade will change the theme to "classic".
-
Okay, thank you very much for your help, I would of been lost. I will try to upgrade as long as I will not loose anything. I won't loose all of my categories, albums, or files in the albums will I?
-
You won't lose anything if you do it properly.
-
Ok, I went to the upgrade docs and the first thing it says to do is to "First, make a backup (dump) of your database." Can I do this seeing I can't get to my gallery?
-
You can make the dump using any database admin tool, such as phpmyadmin.
-
OK thank you very much. I save my datebase just by exporting it then? I did this and its just a bunch of text.
-
Yes, that's what a dump looks like.
-
I'll have to go find a beta release to figure out what the "core" theme is
Here are the download links (hidden on the official downloads page) for older versions:- cpg1.4.0 (alpha) (http://prdownloads.sourceforge.net/coppermine/cpg1.4.0_alpha.zip?download)
- cpg1.4.1 (beta) (http://prdownloads.sourceforge.net/coppermine/cpg1.4.1_snapshot2005-02-12.zip?download)
- cpg1.4.1 (beta2) (http://prdownloads.sourceforge.net/coppermine/cpg1.4.1_beta.zip?download)
Dev-only thread that explains the naming scheme: http://forum.coppermine-gallery.net/index.php?topic=12899.msg78327#msg78327
-
I followed the upgrade instructions and upgraded to version 1.4.3 but now when I try to go to my gallery I get the following:
Coppermine Photo Gallery seems not to be installed correctly, or you are running coppermine for the first time. You'll be redirected to the installer. If your browser doesn't support redirect, click here.
When I click the "click here" link I get the following:
• • • ERROR • • •
The installer has already been run successfuly once and is now locked.
If you want to run the installer again, you first need to delete the 'include/install.lock' file that was created in the directory where you put Coppermine. You can do this with any FTP program.
Would deleting the lock file and reinstalling fix this? And would I still be able to have all of the content as I did before this mess? I saved the datebase as instructed in the upgrade.
-
What did you do with your include/config.inc.php file ?
-
I copied that file to my hard drive as well as the anyconntent.php file.
-
Make sure you copied it and did not move it. You are getting that message because that file is not there.
-
Ok, I just checked and the config.inc.php file was not there so I uploaded the copy that I saved. Now when I go to my gallery I get this:
Fatal error :
-
Is this when you go to the main page or when you go to the installer?
-
This is when I go to the main page.
-
What happens when you run "update.php"?
-
When I run the update it shows the following at the bottom:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mounted-storage/home8/sub001/sc14959-TCLB/LN/members/gallery/update.php on line 47
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mounted-storage/home8/sub001/sc14959-TCLB/LN/members/gallery/update.php on line 50
Upgrade completed
And I tried to go to my gallery after I did this and it is still the same.
-
Make sure include/config.inc.php contains correct information about your database.
-
It sounds like your config.inc.php is not set up properly. update.php cannot find your existing Coppermine database tables. You need to have the correct name of your database and the table prefix (and the connection information). Are you using the one from your previous installation? You can edit config.inc.php with a text editor and check the information.
Yeah, what Nibbler said.
-
It has all the correct info as far as datebase name, user name, and password. The other info in the file is:
$CONFIG['TABLE_PREFIX'] = 'cpg140_';
and I checked my phpmy admin and the table names are as follows so I dont see what is wrong with that.
cpg140_albums
cpg140_banned
cpg140_bridge
cpg140_dict
cpg140_ecards
cpg140_exif
cpg140_favpics
cpg140_filetypes
cpg140_hit_stats
cpg140_plugins
cpg140_sessions
cpg140_temp_data
cpg140_vote_stats
-
While you are in phpmyadmin, use the SQL tab to run the query
UPDATE cpg140_config set value = 1 where name = 'debug_mode'
Then go back to your gallery.
-
I tried to run that query and got the following:
Error
SQL-query:
UPDATE cpg140_config SET value =1 WHERE name = 'debug_mode'
MySQL said:
#1146 - Table 'kyle1.cpg140_config' doesn't exist
-
What happened to your config table ?
I suggest you restore your dump and try the update again.
-
Or maybe your database name is set incorrectly? Is your database named 'kyle1'?
-
Yes, the datebase name is kyle1 which cant be changed, its my hosts user name and then the datebase number.
So Nibbler are you saying to just run the datebase file i saved and then do another update? Or do I have to do anything else?
-
Yes. To restore a dump, you go to SQL in phpMyAdmin, then run the text file with the dump. (The dump is a list of SQL commands that will restore your database.) This will create the config table which is apparently missing. Then Coppermine's update.php should be able to update your 1.4.0 gallery to 1.4.3.
-
This is what I get when I try to run that file:
Error
SQL-query:
-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: mysql6.servage.net
-- Generation Time: Jan 30, 2006 at 11:26 PM
-- Server version: 5.0.15
-- PHP Version: 4.3.3
--
-- Database: `kyle1`
--
-- --------------------------------------------------------
--
-- Table structure for table `cpg140_albums`
--
CREATE TABLE `cpg140_albums` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) NOT NULL default '',
`description` text NOT NULL ,
`visibility` int( 11 ) NOT NULL default '0',
`uploads` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`comments` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`votes` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`pos` int( 11 ) NOT NULL default '0',
`category` int( 11 ) NOT NULL default '0',
`thumb` int( 11 ) NOT NULL default '0',
`keyword` varchar( 50 ) default NULL ,
`alb_password` varchar( 32 ) default NULL ,
`alb_password_hint` text,
PRIMARY KEY ( `aid` ) ,
KEY `alb_category` ( `category` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =481
MySQL said:
#1046 - No database selected
-
That means you clicked on SQL from outside a database. You need to click on a database first, then click on the SQL tab so that all SQL commands will be executed on the current database.
When you export a database, you can choose to have it include the database name so all the tables have "absolute" references, but most people use the relative references since in many cases, you do not or cannot create the database.
-
Ok this is what I got back after I tried running that file:
MySQL said:
#1050 - Table 'cpg140_albums' already exists
Should I delete these and try again?
-
Does the import quit after this error message or does it give the error message and continue running? If the latter, you're all set. If the former, yeah, you need to delete the current tables and then restore from the dump. As Nibbler asked earlier, I'm not sure what happened to your config table originally. Something's weird with your sudden problem.
When you export your database, you can obviate the need for doing the manual delete before restore by checking the box "Add DROP TABLE" or you can check "Add IF NOT EXISTS" in the current releases of phpMyAdmin and then no delete tables is necessary - tables will only be added in the restore if the table doesn't already exist.
-
I jsut keep getting error after error. I droped the contents of the datebase and ran the file and recieved the following:
Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 59
STR: />
SQL: --
-- Dumping data for table `cpg140_hit_stats`
--
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/servage_net/secure/admin/phpMyAdmin-2.6.1/export.php:120) in <b>/home/servage_net/secure/admin/phpMyAdmin-2.6.1/libraries/header_http.inc.php</b> on line <b>14</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/servage_net/secure/admin/phpMyAdmin-2.6.1/export.php:120) in <b>/home/servage_net/secure/admin/phpMyAdmin-2.6.1/libraries/header_http.inc.php</b> on line <b>15</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/servage_net/secure/admin/phpMyAdmin-2.6.1/export.php:120) in <b>/home/servage_net/secure/admin/phpMyAdmin-2.6.1/libraries/header_http.inc.php</b> on line <b>16</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/servage_net/secure/admin/phpMyAdmin-2.6.1/export.php:120) in <b>/home/servage_net/secure/admin/phpMyAdmin-2.6.1/libraries/header_http.inc.php</b> on line <b>17</b><br />
<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at /home/servage_net/secure/admin/phpMyAdmin-2.6.1/export.php:120) in <b>/home/servage_net/secure/admin/phpMyAdmin-2.6.1/libraries/header_http.inc.php</b> on line <b>20</b><br />
<?xml version="1.0" encoding="utf-8"?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<base href="https://secure.servage.net/admin/phpMyAdmin-2.6.1/" />
<script language="JavaScript" type="text/javascript">
<!--
/* added 2004-06-10 by Michael Keck
* we need this for Backwards-Compatibility and resolving problems
* with non DOM browsers, which may have problems with css 2 (like NC 4)
*/
var isDOM = (typeof(document.getElementsByTagName) != 'undefined'
&& typeof(document.createElement) != 'undefined')
? 1 : 0
SQL-query:
-- -- Dumping data for table `cpg140_hit_stats` --
Warning: Cannot modify header information - headers already sent by (output started at /home/servage_net/secure/admin/phpMyAdmin-2.6.1/export.php:120) in /home/servage_net/secure/admin/phpMyAdmin-2.6.1/libraries/header_http.inc.php on line 14
Warning: Cannot modify header information - headers already sent by (output started at /home/servage_net/secure/admin/phpMyAdmin-2.6.1/export.php:120) in /home/servage_net/secure/admin/phpMyAdmin-2.6.1/libraries/header_http.inc.php on line 15
Warning: Cannot modify header information - headers already sent by (output started at /home/servage_net/secure/admin/phpMyAdmin-2.6.1/export.php:120) in /home/servage_net/secure/admin/phpMyAdmin-2.6.1/libraries/header_http.inc.php on line 16
Warning: Cannot modify header information - headers already sent by (output started at /home/servage_net/secure/admin/phpMyAdmin-2.6.1/export.php:120) in /home/servage_net/secure/admin/phpMyAdmin-2.6.1/libraries/header_http.inc.php on line 17
Warning: Cannot modify header information - headers already sent by (output started at /home/servage_net/secure/admin/phpMyAdmin-2.6.1/export.php:120) in /home/servage_net/secure/admin/phpMyAdmin-2.6.1/libraries/header_http.inc.php on line 20
-
Unknown Punctuation String? Wow, that's strange. If phpMyAdmin created that file, it should be able to add it back in again. This looks to me like a phpMyAdmin mistake. Your phpMyAdmin version is a little old, so there's a chance that that version had a bug but I would guess that that chance would be slim. But I don't know what else could cause that.
I would look in the dump file, searching for "cpg140_hit_stats", then look to see if any of the data you have in there has any quotes (single or double) that are not escaped. (Escaping a quote means to put a backslash in front of it, like this: \" or \'.)
But the next errors about "headers already sent" is strange as well. I don't know if that is a follow-on error caused by the first one (and so nothing to worry about once you fix the first one), or if it is more a cause of the errors as a whole.
If your site is not a porn site, I'd be willing to take a look at the database and the database dump and the site to see if I can see directly what's wrong. You can PM me the information. If you like your current password, change it first to something else (on the database and in your Coppermine/include/config.inc.php). We'll still discuss things here publicly, but then I'd have first-hand information on what's going on.
If your site is a porn site (or something else that might be offensive to sensitive eyes), I'm loathe to spend the extra effort, but I am willing to continue helping here.
-
I do see some quotes that do not have a backslash. Are these what is causing this problem now? Is there something wrong or any reason that I keep having all of these problems?
-
Well, I should be more specific about escaping the quotes. SQL commands use quotes around table names and around field names and around values to put in the table. The problem is when there is a rogue quote inside one of these pieces of text that is not escaped. So if you have a value that is 'Tom's Boat', you see that the apostrophe will close out the first single quote, and then the rest is not part of the string anymore. It should be 'Tom\'s Boat' to properly add the value to the database.
-
So should I add back slashes in? I can show you the portion of the datebase you are reffering to if that would help.
-
If there are values that have quotes and are not escaped, then yes, add the backslashes to escape those quotes. Make sure not to escape quotes used around values like in my example: 'Tom\'s Boat' - the beginning and ending quotes are not escaped.
Sure, you can paste some of the database here. (an attachment might be better than inline)
-
Ok, I went through the part of the datebase that you mentioned, and it looks ok as far as I can see based on the instructions you gave. I have atached this part.
-
Was there any input on this, or any reason I have this problem? Is it fixable?