Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Koosje

Pages: [1]
1
All the time the news is appearing on the frontpage, but as soon I click for more news, the error message is gone but no news is showing up. Only the working paging. The header is saying "No news" while there are more as 10 newsmessages. I've the next changes in news.php in the root section:

if($news_id=="")
   $sql = "SELECT news_id, news_title, news_text, news.user_name, news_date, news.user_id, users.userpic FROM ".NEWS_TABLE." news, deplane_users users WHERE users.user_id = news.user_id ORDER BY news_date DESC LIMIT $offset, $newsPerPage";
   else
    $sql = "SELECT news_id, news_title, news_text, news.user_name, news_date, news.user_id, users.userpic FROM ".NEWS_TABLE." news, deplane_users users WHERE users.user_id = news.user_id AND news_id = ".$news_id." ORDER BY news_date DESC LIMIT $offset, $newsPerPage";
   

2
But it did work before the changes, so I have undone the changes.
DB Error Bad SQL Query: SELECT news_id, news_title, news_text, news.user_name, news_date, news.user_id, users.userpic FROM deplane_news news, deplane_users WHERE users.user_id = news.user_id ORDER BY news_date DESC LIMIT 0, 5 Unknown table 'users' in field list

3
Please read step 6 of my signature. What is say / do for unexpected error message ? What is exact error text ?


the error message is : "An unexpected error has occured. Please try again later"

4
Thanks for the information. But when i've changed the two tips, mentioned above i've got an unexpected error, and the news pages are empty.................

6
If I use this mod I cannot login anymore.

7
@thunderstrike
Can you tell me how, this is to complecated for me? thanks already!

8
Is it possible to ask a news item at once by knowing his id like the thumbnails does. This wil ask a link like "details.php?image_id=xx".
A link like news.php?news_id=xx shows the whole page.

9
Discussion & Troubleshooting / Re: No paging at search results
« on: August 09, 2007, 07:06:41 PM »
I've put setperpage_dropdown_form back to it, so visitors can choose the number of rows. I can live with that. Dunno how to to do it without paging. The other thing is that the rows will be ordered like the way it is set at the settings. Default is now ordered by date. Is het possiible to ask it, ordered by imagename without changing the settings?

10
Discussion & Troubleshooting / Re: No paging at search results
« on: August 05, 2007, 12:07:28 PM »
@thunderstrike
It is a site map. If you link to a catagory, you'll see thumbnails catched in paging as well. Actually I mean this, as you can see in the image below. A rebuild search form, but I wan't to have it without the paging.

<img src="http://www.ossensia.nl/Image3.jpg">

11
Discussion & Troubleshooting / No paging at search results
« on: August 05, 2007, 03:53:59 AM »
I would like to have a list without the thumbnails, so I can have an overview overall. I'm working on it but, I'm bordered by the paging. It shows a list wich is limited by num_rows wich is set with the settings. To have a complete list I've to set this to a high number ex. 1000, print it out and return it toe a lower number. Not very easy. Anybody an answer about this?

12
Mods & Plugins (Requests & Discussions) / Listing without thumbnails
« on: July 27, 2007, 10:14:11 AM »
How is it possible to have a listing without thumbnails extra besides the one with thumbnails? This as a short overview of all or searched pics.

13
Mods & Plugins (Releases & Support) / Re: [MOD]News archive
« on: July 27, 2007, 10:09:58 AM »
In this discussion is becomming complecated because there are so many reactions. What I do, I still don't have a news page with the archive. News is very well installed, MySql-database works, the latest news on the frontpage works, news settings works, paging on news.php works. Permissions are set. Is there a new mod with the right modifacations en installation guide.

Pages: [1]