On these pages are my WordPress plugins, the odd article and my Support Forum.

For my random rantings on everything else please visit my blog at Yellow Swordfish

WP Plugins


Articles

If you find any of my plugins useful, please comsider a donation towards my running costs.

Thank you

Current User: Guest
Please consider registering

 
Search Forums:


 




Database Error

UserPost

3:51 pm
4 Oct 2007


Lucas

Guest

 
1

First of all sorry for my english…

I’m really glad to use your plugin, it’s so easy to handy and I love it.

Anyway i go for the important. When i try to review the list of all pages i receive a message from the database in the space i should have had the list of subscribers to all pages.

You can see the message on the capture, anyway i paste it here for you.

WordPress database error: [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 'Pages ORDER BY wp_punmail.email' at line 1]
SELECT wp_punmail.id, wp_punmail.post_id, wp_punmail.email, wp_posts.post_title FROM wp_punmail LEFT JOIN wp_posts ON wp_punmail.post_id = wp_posts.ID WHERE wp_punmail.post_id = All Pages ORDER BY wp_punmail.email

I did some changes on the template, on several archives… maybe it’s because of that. So on, i have no idea of data bases, so i hope it colud be possible from you to give me a dummy solution. I should learn more, i know…

Ah, in another line, i’m gonna try to modified your template to make the subscription to all pages as the normal subscription.

bloody hell, i hope you understand my english! Anything you need i’ll be checking your site and my email.

thanks a lot

lucas

1:56 am
5 Oct 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5009

 
2

have you by any chance deleted some posts? That’s what it looks like and if that is the case then it also looks like you may have uncovered a proper bug in the plugin…

2:35 am
6 Oct 2007


Lucas

Guest

 
3

Yes, i think i did it. And then i uninstalled the plugin and installed it again and nothing worked… i’ll try to do it from the beginning again and i’ll tell you what happens. Thanks a lot

2:42 am
6 Oct 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5009

 
4

Be a good idea to remove the table as well if possible. Check the option in the Notifications admin panel to remove all data.

if it’s not possible to remove the table (because you want to preserve data) then  will have to help you remove the offending entries. 

11:39 am
11 Nov 2007


Paul

Guest

 
5

Hi, got the same problem as mentioned above. Just installed the plugin. I get the following message when click the button :

SELECT wp_punmail.id, wp_punmail.post_id, wp_punmail.email, wp_posts.post_title FROM wp_punmail LEFT JOIN wp_posts ON wp_punmail.post_id = wp_posts.ID WHERE wp_punmail.post_id = All Pages ORDER BY wp_punmail.email

Any ideas how i can solve this? (using latest WP version)  and never used this plugin before… But used to us Subscribe2, but that did not function properly with the new release…

Thanks in advance,

Paul 

 

 

12:07 pm
11 Nov 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5009

 
6

Sorry about this. I am going to email you a replacement code file for the plugin. I would be grateful if you can tell me of this resolves the problem so I can update the master.

12:09 pm
11 Nov 2007


Paul

Guest

 
7

Found the error Cool:

Subscribe2 changes the: buttonsnap.php file. Changed it back and the problems are fixed !

Thanks for this nice plugin 

 Paul

So i can’t unforunately test for you the new code…

12:56 pm
15 Nov 2007


Aouni

Guest

 
8

Dear Admin,

 Unfortunately I also get this error whenever I click the [View List] link that is beside the All Pages ID in the Admin panel. Note that I checked the database tables and found that visitors of my site are subscribing successfully, however this error is preventing me those emails subscribing to all pages.

Sincerely,
Aouni Tahech

1:10 pm
15 Nov 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5009

 
9

Take the latest download. It has been upgraded and fixes this problem.

8:50 pm
16 Nov 2007


angelo

Guest

 
10

hallo,

i’can’t activate the plugin.

it reports me a fatal error:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 58368 bytes) in /home/web/www.democraziatrepuntozero.it/website/wp-content/plugins/simple-forum/sf-page.php on line 243

i’can’t understand the reason why

i hope this is the right place in the forum for this question…

thanx 


 

8:55 pm
16 Nov 2007


Mr Papa

Moderator

Arizona, USA

posts 1437

 
11

what is your memory limit set to in your php.ini file?  you should try increasing it…

9:01 pm
16 Nov 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5009

 
12

Mr Papa: Can he DO that? On a hosted system? Well I assume hosted.

Angelo: Are you using a huge amunt of plugins? You’ve used up all of your memory allocation. 

Oh - and you’ve posted this to the wrong forum by the way - not that I guess it matters that much!

11:06 pm
16 Nov 2007


Mr Papa

Moderator

Arizona, USA

posts 1437

 
13

some you can, some you cant… more and more are allowing it…  mine does…

12:01 pm
17 Nov 2007


angelo

Guest

 
14

i only have 2 plugin activated (video plugin, akismet).

when i install other plugins they work.

where could be the problem?

thanx

angelo 

12:50 pm
17 Nov 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5009

 
15

As we said, you don’t have enough php memory available. You need to discuss this with your host as they are they people who allocate your site memory.

8:38 pm
17 Nov 2007


angelo

Guest

 
16

i really don’t understand of what kind of memory you are talking about.
web space on the server?
i’ve just installed vanillla forum (indeed i don’t like it) in the same web space and it works.

however thanks, i will ask to my hosting service asa

sincerely

angelo 

 

8:46 pm
17 Nov 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5009

 
17

This is not a disk space problem. This is RAM - Memory. On the server. Your host allocates so much RAM to run php in (the language WordPress is written it). In your case, you have run out.

12:20 am
18 Nov 2007


Mr Papa

Moderator

Arizona, USA

posts 1437

 
18

if you can get at your php.ini file (ask your host) find the line

memory_limit = 8M

might be some other value… try increasing it to 32M

or you can add a line to .htaccess to do the same (still may not work though depending on your host).  add this line to the .htaccess file in your wordpress root directory


php_value memory_limit 32M
 

12:23 am
18 Nov 2007


Yellow Swordfish

Admin

Peterborough, England

posts 5009

 
19

Wow! Can I have 32 as well please… Wink

11:54 am
19 Nov 2007


angelo

Guest

 
20

thanx

i’ll try   :-)) 



Reply to Topic: Database Error

NOTE: New Posts are subject to administrator approval before being displayed

Guest Name (Required):

Guest EMail (Required):

Guest URL (required)

Math Required!
What is the sum of: 9 + 4        (Required)

Topic Reply:


 
 

About the Stuff at Yellow Swordfish forum

Currently Online:

Yellow Swordfish

14 Guests

Maximum Online: 71

Forums:

Groups: 3

Forums: 16

Topics: 1940

Posts: 13153

Members:

There are 916 members

There are 795 guests


Yellow Swordfish has made 5009 posts

Top Posters:

Mr Papa - 1437

-Radio- - 518

ovizii - 106

jfv - 82

RoseCitySister - 68

Administrator: Yellow Swordfish | Moderators: Yellow Swordfish, Mr Papa, -Radio-


© Simple:Press Forum - Version 3.1.4 (Build 357)