Toggle Content

Donations

Donate with PayPal!
Help support Pro_News and become a member of our Sponsors Group
The tip jar is at PayPal, but does not require a PayPal account
Anonymous $ 10.00
macavity $ 115.00
RedGerry £ 50.00
Anonymous $ 10.00
minor $ 20.00

User Info


Selamat Datang Anonymous


Keanggotaan:
Terakhir: Witewolf
Yang baru hari ini: 0
Yang baru kemarin: 0
Semuanya: 151

Orang yang Online:
Member: 0
Pengunjung: 30
Bots: 2
Total: 32
Who Is Where:
 Pengunjung:
Support Forums
Support Forums
Support Forums
Support Forums
Support Forums
Home
الصفحة الأولى
Support Forums
Support Forums
Support Forums
Support Forums
Support Forums
Support Forums
Pro News Articles
Support Forums
Support Forums
Nedladdningar
Pro News Articles
Support Forums
Support Forums
Support Forums
Support Forums
Hem
Support Forums
Support Forums
Pro News Articles
Support Forums
Downloads
Support Forums
Support Forums
 Bots:
Google > Support Forums
Baidu > Pro News Articles

Staff Online:

No staff members are online!

Recommended ISP

Block Error

3.3 Forum ONLY: If you've run into a problem, such as an error message, blank page, or similar problem, this is where to look. Post any installation or other problems or questions here, and I and other users will try to help.
Kirim balasanKirim balasan Versi Cetak

Block Error

Kirim Dikirim: Fri Sep 10, 2010 5:18 am

changed the new block display from most recent to most popular got this error message:

includes/db/db.php
CMS Warning line 75: On /index.php While executing query "SELECT a.id, a.catid, a.title, s.id ssid, c.id cid, c.sid FROM cms_pronews_articles as a LEFT JOIN cms_pronews_cats as c ON a.catid=c.id LEFT JOIN cms_pronews_sections as s ON c.sid=s.id WHERE a.approved="1" AND a.active="1" AND a.catid!="0" AND s.id="2" ORDER BY counter DESC, LIMIT 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 'LIMIT 5' at line 1 In: /home/a4136642/public_html/modules/Pro_News/functions.php on line: 94


i'll just bet i should have deactivated the module b4 making the changes.
Sad
any advice?



rudy386's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Unix/2.2.13 /5.0.81/5.2/9.2.1

rudy386
Poster
Poster
 
Post: 13
Sejak: Aug 20, 2010
Lokasi: Glasgow, KY.

Re: Block Error

Kirim Dikirim: Fri Sep 10, 2010 6:09 am

No, just a typo in the code.

In modules/Pro_News/functions.php around line 83 look for:

PHP:
				} elseif ($bsets['type'] == 'popular') {
$sql .= ' ORDER BY counter DESC, '.$pnsettings['art_ordr'];
} else {
$sql .= ' ORDER BY score / ratings DESC, '.$pnsettings['art_ordr'];


and replace with:

PHP:
				} elseif ($bsets['type'] == 'popular') {
$sql .= ' ORDER BY counter DESC '.$pnsettings['art_ordr'];
} else {
$sql .= ' ORDER BY score / ratings DESC '.$pnsettings['art_ordr'];



Ie. delete the comma after counter DESC - and after ratings DESC while we're at it.

Let me know if it works, and I'll include in next release - RC release next week, maybe.



layingback's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
2.6.32 / 1.3.39 - 2.2.12 / 4.4.7 - 5.1.37 / 5.3.0 / 9.2.1

layingback
Site Admin
Site Admin
 
Post: 1229
Sejak: Mar 18, 2006

Re: Block Error

Kirim Dikirim: Fri Sep 10, 2010 4:42 pm

did the trick thank you...looking forward to the next release.



rudy386's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Unix/2.2.13 /5.0.81/5.2/9.2.1

rudy386
Poster
Poster
 
Post: 13
Sejak: Aug 20, 2010
Lokasi: Glasgow, KY.

Re: Block Error

Kirim Dikirim: Fri Sep 10, 2010 4:59 pm

wait spoke too soon now. im getting the following error code:

includes/db/db.php
CMS Warning line 75: On /index.php?name=Pro_News&mode=submit While executing query "SELECT a.id, a.catid, a.title, s.id ssid, c.id cid, c.sid FROM cms_pronews_articles as a LEFT JOIN cms_pronews_cats as c ON a.catid=c.id LEFT JOIN cms_pronews_sections as s ON c.sid=s.id WHERE a.approved="1" AND a.active="1" AND a.catid!="0" AND s.id="2" ORDER BY counter DESC 1 LIMIT 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 '1 LIMIT 5' at line 1 In: /home/a4136642/public_html/modules/Pro_News/functions.php on line: 91

includes/classes/blocks.php
Warning line 83: Invalid argument supplied for foreach()
Warning line 83: Invalid argument supplied for foreach()



rudy386's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Unix/2.2.13 /5.0.81/5.2/9.2.1

rudy386
Poster
Poster
 
Post: 13
Sejak: Aug 20, 2010
Lokasi: Glasgow, KY.
Link  QR  Share this Versi Cetak  facebook   myspace   twitthis  
Show more ...
Tampilan pesan sebelumnya:   
Kirim balasanKirim balasan Halaman 1 dari 1

3.3 Support

Navigasi:  



Anda tidak dapat mengirim topik
Anda tidak dapat menjawab topik
Anda tidak dapat mengubah pesan Anda
Anda tidak dapat menghapus pesan Anda
Anda tidak dapat mengikuti polling
You cannot attach files in this forum
You cannot download files in this forum

Zona waktu menurut GMT






layingback Non-Human Terms of Use