23 April 2010, 1:40

setup           Component or plugin	From version	To version	Ok i am using posthres 8.1 and mahara 1.2 and thi is what i get at www.babblefishsn.cm/mahara              Information
core	Not installed	1.2.4	Could not execute command: CREATE TABLE pgsql.so config ( field VARCHAR(255) NOT NULL, value TEXT, CONSTRAINT pgsql.so conf_fie_pk PRIMARY KEY (field) ) Call stack (most recent first):   execute_sql("CREATE TABLE pgsql.so config ( field VARCHAR(2...", true) at /var/www/mahara/lib/dml.php:1385   execute_sql_arr(array(size 222)) at /var/www/mahara/lib/ddl.php:566   install_from_xmldb_file("/var/www/mahara/lib/db/install.xml") at /var/www/mahara/lib/upgrade.php:293 upgrade_core(object(stdClass)) at /var/www/mahara/admin/upgrade.json.php:93
firstcoredata
localpreinst
artefact.internal	Not installed	1.1.0
artefact.resume	Not installed	1.0.0
artefact.file	Not installed	1.2.0
artefact.blog	Not installed	1.1.0
auth.internal	Not installed	1.0.0
auth.xmlrpc	Not installed	1.0.0
auth.saml	Not installed	1.1.0
auth.ldap	Not installed	1.0.0
auth.imap	Not installed	1.0.0
auth.none	Not installed	1.0.0
notification.email	Not installed	1.0.0
notification.internal	Not installed	1.0.1
notification.emaildigest	Not installed	1.0.1
search.internal	Not installed	1.0.0
search.solr	Not installed	1.0.0
blocktype.blog/blog	Not installed	1.0.0
blocktype.file/folder	Not installed	1.0.0
blocktype.blog/recentposts	Not installed	1.0.0
blocktype.file/html	Not installed	1.0.0
blocktype.resume/resumefield	Not installed	1.0.0
blocktype.blog/blogpost	Not installed	1.0.0
blocktype.internal/contactinfo	Not installed	1.0.0
blocktype.internal/profileinfo	Not installed	1.0.0
blocktype.file/filedownload	Not installed	1.0.0
blocktype.externalvideo	Not installed	1.0.0
blocktype.myfriends	Not installed	1.0.0
blocktype.externalfeed	Not installed	1.0.2
blocktype.textbox	Not installed	1.0.0
blocktype.creativecommons	Not installed	1.0.0
blocktype.file/internalmedia	Not installed	1.0.0
blocktype.wall	Not installed	1.0.2
blocktype.mygroups	Not installed	1.0.0
blocktype.myviews	Not installed	1.0.0
blocktype.resume/entireresume	Not installed	1.0.0
blocktype.file/image	Not installed	1.0.0
interaction.forum	Not installed	1.2.1
grouptype.course	Not installed	1.0.0
grouptype.standard	Not installed	1.0.0
import.leap	Not installed	0.1
import.file	Not installed	0.1
export.html	Not installed	0.1
export.leap	Not installed	0.1
lastcoredata
localpostinst

23 April 2010, 8:50

i got it to try and load and well i get this error

Could not execute command: CREATE TABLE pgsql.so config ( field VARCHAR(255) NOT NULL, value TEXT, CONSTRAINT pgsql.so conf_fie_pk PRIMARY KEY (field) )

23 April 2010, 15:14

alright i tried a few thingd now from your foroum and google and notng has helped...can ya help a guy out here

23 April 2010, 20:33

so i found this bit of information ... i feel i may need ro add this to the postgressql ini file... but i am not sure... any one have an opinion

In PostgreSQL the equivalent table might be:

CREATE TABLE serial_exmpl (
  id SERIAL PRIMARY KEY,
  abc TEXT
)    

Replace the NULL with DEFAULT and PostgreSQL will insert the next sequence value for you:

INSERT INTO serial_exmpl VALUES(DEFAULT, 'Remember: NULL is the absence of a value')    

If for whatever reason it is not possible to convert the MySQL statements to use DEFAULT, it is possible to define a trigger on the affected table(s) like this:

CREATE OR REPLACE FUNCTION null_to_default() RETURNS TRIGGER AS '
  BEGIN
    IF NEW.id IS NULL THEN
      SELECT INTO NEW.id nextval(''public.serial_exmpl_id_seq''::text);
    END IF;
    RETURN NEW;
  END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER serial_exmpl_trg BEFORE INSERT ON serial_exmpl
  FOR EACH ROW EXECUTE PROCEDURE null_to_default();

This ensures that insertion of a NULL value will result in automatic conversion to the next sequence value.

so i am going to ttry it and guess were it goes if it goes and i will be back to answer my own post again i guess... you folks are letting me down here... cant any one find the rime to give me a bit of encouragement or even a hint