missing new posts?
not exactly
the site went KAPOOF when i upgraded a month ago to latest version DF CMS.
No idea what happened but blocks were all over the place showing up in pages they couldnt possably exist more or less. Since i couldnt get it worked out fast enough i went into my admin panel on DF and tried to upload a backup file.
it went in but messed things up even more.
I later realized that the upgrade added more tables into SQL so my back which was made before the upgrade was useless.
it only contained DUMP DATA and not the SQL data to creat tables so i couldnt do a full SQL restore from the server C-PANEL
here is what i had to do
I still had all the DUMP data from the sql tables.
This meant Posts, news (mostly) CPG info, PMs, Users and their account info.
Pretty much everything that would consist of CONTENT for the site.
So i had to make a secondary install of DF
goto server C Panel > MySql phpMyAdmin
Find all DF tables
Empty all these tables
Upload the DF admin sql back file which added all the content into the NEW DF install.
However this may have also resulted in adding in PMs dated / created older then the DF installation itself.
Well theres my total package
got any ideas?
If not,
is there a way i can go in and globally DELETE all PMs ?
Please enter your server specs in your user profile! 😢
NanoCaiordoOffline
Joined: Jun 29, 2004
Posts: 4368
Location: Italy
Member List Error: includes/db/db.php
CMS Warning line 75: On /index.php?name=Members_List While executing query "SELECT * FROM ut3_bbthemes WHERE themes_id = " the following error occured: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 In: /home/dogsofwa/public_html/ut3/includes/phpBB/functions.php on line: 145
PM Error includes/db/db.php
CMS Warning line 75: On /index.php?name=Members_List While executing query "SELECT * FROM ut3_bbthemes WHERE themes_id = " the following error occured: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 In: /home/dogsofwa/public_html/ut3/includes/phpBB/functions.php on line: 145
Groups Error includes/db/db.php
CMS Warning line 75: On /index.php?name=Groups While executing query "SELECT * FROM ut3_bbthemes WHERE themes_id = " the following error occured: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 In: /home/dogsofwa/public_html/ut3/includes/phpBB/functions.php on line: 145
Line 145:
$result = $db->sql_query("SELECT * FROM ".THEMES_TABLE." WHERE themes_id = $style");
Most everything else works flawlessly.
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/Apache2/MySQL4/PHP4/9.1.2.1
Mac_ManOffline
Joined: Jun 25, 2006
Posts: 11
Location: Spartanburg, SC
Line 145: $result = $db->sql_query("SELECT * FROM ".THEMES_TABLE." WHERE themes_id = $style");
I wanted to see what the value of $style was. I added an echo "Style=".$style; to the function.
When I ran the member list page again, I received: Style=
Looking at the DB and specifically, bbthemes table, only one theme is listed SubSilver -- ThemeID= 1. OK, no problem.
The function "setup_style" is getting a variable passed to it, $style, which in my case has no value. That's why I keep getting errors when that function is called.
I added a line in the function:
$style = 1;
I ran my members page, PM's, and groups page. No errors at all and they work great. Somewhere in the code $style is not getting defined. Not sure the problem, but I was able to come up with a fix.
----
Here is what my /includes/phpbb/functions.php looks like:
function setup_style($style)
{
$style=1;
global $db, $board_config, $template, $cpgtpl, $images, $phpbb_root_path, $CPG_SESS;
$result = $db->sql_query("SELECT * FROM ".THEMES_TABLE." WHERE themes_id = $style");
if (!($row = $db->sql_fetchrow($result))) {
message_die(BB_CRITICAL_ERROR, "Could not get theme data for themes_id [$style]");
}
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/Apache2/MySQL4/PHP4/9.1.2.1
NanoCaiordoOffline
Joined: Jun 29, 2004
Posts: 4368
Location: Italy
On /index.php?name=Private_Messages
While executing query "SELECT privmsgs_id FROM ut3_bbprivmsgs
WHERE ( privmsgs_type = 1
OR privmsgs_type = 0
OR privmsgs_type = 5 )
AND privmsgs_date =
AND privmsgs_to_userid = 5"
the following error occured: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND privmsgs_to_userid = 5' at line 6
--------------------
privmsgs_date = blank
This is a brand new install and I have not had problems with PM's on a site that has been upgraded to 9.1.2.1
This happens on the default and other installed themes.
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/Apache2/MySQL4/PHP4/9.1.2.1
NanoCaiordoOffline
Joined: Jun 29, 2004
Posts: 4368
Location: Italy
@Mac_Man, I'm not sure if you have modified the code, but try uploading all files again and browse it using the default theme. All those kind of problems have been templates related.
.:: I met php the 03 December 2003 :: Unforgettable day! ::.
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.7 / PHP 7.3 / head
Mac_ManOffline
Joined: Jun 25, 2006
Posts: 11
Location: Spartanburg, SC
