Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Page Publisher:
Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105.

 
 


kingkong
User

Jul 27, 2005, 9:46 AM

Post #1 of 14 (8208 views)
Shortcut
Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. Can't Post
After going through the initial install wizard and clicking NEXT, I get the following error.

I have re-uploaded the script several times, it continues to do this.


Cliff
Staff


Jul 28, 2005, 10:39 AM

Post #2 of 14 (8166 views)
Shortcut
Re: [kingkong] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
Hi kingkong,

Thanks for posting.

I suspect that there is a permissions setting on your server that is preventing the script from installing properly. Normally, Perl scripts run with no need to set any permissions on Windows Servers. However, in some instances, the server might not be setup to allow the Perl CGI scripts to have "Write Access" to their files. If this is the case than the program will display a message indicating that it is unable to write to it's data files.

In order for Page Publisher to properly function, it needs to be able to rename a file by overwriting an existing file that already has that same name. You'll want to contact your hosting provider and make sure rename permissions are set to the /pp/ directory and all subdirectories. These permissions must be set to the user that Perl is running as. This is generally IUSR_Servername (Where Servername is the name of your server).

Once you get these permissions set, the installation script will run just fine and you should have no trouble finishing the installation of Page Publisher.

Give that a try and let me know how that goes Smile
Regards,
Cliff Stefanuk - Customer Service Manager
[email]support@interactivetools.com[/email]


kingkong
User

Jul 28, 2005, 11:48 AM

Post #3 of 14 (8157 views)
Shortcut
Re: [Cliff] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
Our sysadmin made the change, but had this question/concern for you:


I have no problem doing this for the install phase. However, we should not keep the rights configured as such because it is a security concern. I am assuming that once the install is complete, we can remove the write privileges to the script directory without breaking the application?



kingkong
User

Jul 28, 2005, 11:52 AM

Post #4 of 14 (8156 views)
Shortcut
Re: [kingkong] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
well, nevermind, because although he made the changes, I am still getting the same error.

After I finish the Product ID phase and choose next, the error still shows up:



Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105.


kingkong
User

Jul 28, 2005, 12:39 PM

Post #5 of 14 (8144 views)
Shortcut
Re: [kingkong] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
also, from sys. admin:

Yes, that appears to be a bona fide programming error. In the "sd" subroutine, there is a call to the "sq" subroutine:

sub sd {
my($msg)=(@_);
my($file_error)=$!;
if($file_error eq'') {
$file_error="Unknown error.Maybe disk quota exceeded?"
}
&sq("$msg : $file_error\n")
}

Of course, there is no "sq" subroutine so the call fails. I did a text search of the entire contents of the pp/ directory, and there are no other instances of the string "sq".


Cliff
Staff


Jul 28, 2005, 1:08 PM

Post #6 of 14 (8139 views)
Shortcut
Re: [kingkong] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
Hi kingkong,

Thanks for posting the additional details.

I think that I'd better take a closer look at this for you, so can I get to fill in an installation request so I can see what is happening. I will be able to resolve this from there, and then post my findings for the community.

I also want to address your System Administrators security concerns.

Basically, by giving the default internet user these permissions, only Perl scripts installed on your hosting account should be able to update the files within folders with Read/Write permissions. Just as how FTP works on your server (when logging in via FTP you should only be able to access/browse your own files and folders) CGI has to be set up in a similar way.

We put our software through constant security audits, and wouldn't ever make you use something that could impose a threat to your server.

Anytime you install web software which needs to keep track of changing data, you'll need to give permissions to the script to be able to make the appropriate changes (reading, writing, and erasing) to its files. Setting permissions like this is a normal requirement for installing any web software.
Regards,
Cliff Stefanuk - Customer Service Manager
[email]support@interactivetools.com[/email]


kingkong
User

Jul 29, 2005, 7:00 AM

Post #7 of 14 (8121 views)
Shortcut
Re: [Cliff] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
I have made the request with our system admins, but I am not sure if it will get approved. Security is very heavy here, so we may have to continue trouble shooting this via another way.



I would like to test the installation on another server to ensure nothing is wrong with my files. Would installing it on another server (and subsquently entering our product info for it) void any future installs (after I delete it from the test server)?


ross
Staff / Moderator


Jul 29, 2005, 10:42 AM

Post #8 of 14 (8112 views)
Shortcut
Re: [kingkong] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
Hi Kingkong.

Thanks for the update!

There’s no problem with installing the software onto another site for testing purposes. If you find that the second server is going to work better for you, just remove it off the first server.

Let me know if you run into any trouble on your new server Smile.
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Product Specialist
support@interactivetools.com

Hire me!  Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/



kingkong
User

Jul 29, 2005, 10:48 AM

Post #9 of 14 (8111 views)
Shortcut
Re: [ross] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
Well, the issue is, all of the documents I need PP to edit are located on the server which is not working. I just want to isolate the problem a bit more by bringing in another server.


kingkong
User

Aug 1, 2005, 12:24 PM

Post #10 of 14 (7992 views)
Shortcut
Re: [kingkong] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
Ok -- I have submitted an Installation request.

Thank you, and please keep me up to date with the progress.


kingkong
User

Aug 5, 2005, 12:04 PM

Post #11 of 14 (7851 views)
Shortcut
Re: [kingkong] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
Well, looks like the Installation is working now. Thank you for your support and speed!


MikeB
Staff / Moderator


Aug 6, 2005, 10:56 AM

Post #12 of 14 (7821 views)
Shortcut
Re: [kingkong] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
Hi,

Thanks for the update! Smile

I'm glad to hear that your installation of Page Publisher is up and running now and that you'll be able to edit the pages on your site again.

If you have any other questions or comments you can feel free to let me know! Smile

Cheers,
Mike Briggs - Product Specialist
support@interactivetools.com

[hr][i][url "http://www.interactivetools.com/consulting/"][b]Hire me![/b][/url]
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with [url "http://www.interactivetools.com/consulting/"][b]Priority Consulting[/b][/url].[/i]


kingkong
User

Aug 6, 2005, 12:34 PM

Post #13 of 14 (7820 views)
Shortcut
Re: [MikeB] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
I'm going to attempt to modify the htmlArea script for use with firefox and Mac Safari as well as output XHTML compliant code.



Those two items are a big big neccessity you guys need to get installed :)


MikeB
Staff / Moderator


Aug 6, 2005, 4:53 PM

Post #14 of 14 (7818 views)
Shortcut
Re: [kingkong] Error : Undefined subroutine &main::sq called at /mnt/smb/web/www.med.ufl.edu/pp/pp.cgi line 105. [In reply to] Can't Post
Hi,

Thanks for the post! Smile

We recently released a version of our Article Manager product with a cross-browser WYSIWYG editor. Now that we've done that it should be easier for us to incorporate this into our other products in the future.

I'm not too sure what the timeline is for a cross browser WYSIWYG in Page Publisher as our developers are currently working on a large Article Manager upgrade, but hopefully this is something our developers will take a look at in the future.

If you have any other questions or comments you can let me know! Smile

Cheers,
Mike Briggs - Product Specialist
support@interactivetools.com

[hr][i][url "http://www.interactivetools.com/consulting/"][b]Hire me![/b][/url]
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with [url "http://www.interactivetools.com/consulting/"][b]Priority Consulting[/b][/url].[/i]