The code works fine in PREVIEW mode, but it runs in to an error in PUBLISH mode

Ask the community
,
1

Hi.
My code works fine during preview. however code didn’t work during publish.
The error is ‘workerLogger.js:103’→’originalFunc.apply(consoleInstance, arguments)’.
In Preview mode, the code works fine and all data insert in DB. However, In Publish mode, data didn’t insert in DB. So I pressed ‘F12’ to check and found this error(‘workerLogger.js:103’). I don’t know about the error.
I have been desperately wrestling with this problem for the past 3 weeks!!!
I have not been able to figure it out.
HELP ME!!

  1. ↓ Preview mode(code works and ‘save finish’)

1913×622 104 KB

  1. ↓ Publish mode(code didn’t work and ‘save fail’)

1103×849 175 KB

  1. code
import wixData from 'wix-data';
import wixLocation from 'wix-location';
import {session}from 'wix-storage';

function showZero() {
  $w('#slideshow').changeSlide(0);
  $w('#first').disable();
  $w('#second').disable();
  $w('#third').disable();
  $w('#firstLine').hide();
  $w('#secondLine').hide();
  $w('#thirdLine').hide();
 //$w('#image1').hide();
  $w('#shape3').show();
}

function showFirst() {
  $w('#slideshow').changeSlide(1); //slide 1
  $w('#first').disable();
  $w('#second').disable();
  $w('#third').disable();
  $w('#firstLine').show();
  $w('#secondLine').hide();
  $w('#thirdLine').hide();
}

function showSecond() {
  $w('#slideshow').changeSlide(2); //slide2
  $w('#first').disable();
  $w('#second').disable();
  $w('#third').disable();
  $w('#firstLine').hide();
  $w('#secondLine').show();
  $w('#thirdLine').hide();
}

function showThird(){
  $w('#slideshow').changeSlide(4); //slide4
  $w('#first').disable();
  $w('#second').disable();
  $w('#third').disable();
  $w('#firstLine').hide();
  $w('#secondLine').hide();
  $w('#thirdLine').show();
}

function showFourth(){
  $w('#slideshow').changeSlide(3); //THANKYOU page
  $w('#first').disable();
  $w('#second').disable();
  $w('#firstLine').hide();
  $w('#secondLine').hide();
  $w('#thirdLine').hide();
}

export function new_click(event) {
  showZero();
}

export function first_click(event) {
  showFirst();
}

export function second_click(event) {
  showSecond();
}

export function third_click(event) {
  showThird();
}

//when press zero button
export function newbutton_click(event) {
  showFirst(); 
}

//when pressed next button
export function saveandnextbutton_click(event) {
  showSecond();
}

//save DB
export function savebutton_click(event) {
  console.log("press save button");
 let toInsert = {
 "title" : $w('#title').value,
 "photo" : $w("#image1").src,
 "startdate" : $w('#datePicker1').value,
 "findate" : $w('#datePicker2').value,
 "story" : $w('#textBox3').value,
 "effect" : $w('#textBox4').value,
 "membercount" : Number($w('#input2').value),
 "runtime" : Number($w('#input3').value),
 "count" : Number($w('#input4').value),
 "cost" : Number($w('#input5').value),
 "targetnumber": Number($w('#input6').value),
 "targetprice" : Number($w('#input7').value),
 "special" : $w("#richTextBox1").value,
 "place" : $w('#input8').value,
 "address" : $w('#input9').value,
 "seatcount" : Number($w('#input10').value),
 "placesize" : Number($w('#input11').value),
 "planimg1" : $w('#image12').src,
 "planimg2" : $w('#image13').src,
 "stagespecial": $w('#richTextBox2').value,
 "outimg" : $w('#image14').src,
 "inimg" : $w('#image15').src,
 "stageimg" : $w('#image16').src,
 "seatimg" : $w('#image17').src,
 "setupimg" : $w('#image18').src,
 "entimg" : $w('#image19').src
 };

wixData.insert("Team", toInsert)
 .then( (results) => {
 let item = results; //see item below
    console.log("save finish");
 //showFourth(); //move to slide 4
 //wixLocation.to('/team'); 
 } )
 .catch( (err) => {
 let errorMsg = err;
    console.log("save fail");
 } );

wixLocation.to('/team'); 

}

//poster
export function uploadButton_change(event) {
$w("#uploadButton").uploadFiles()
 .then( (uploadedFiles) => {
    uploadedFiles.forEach(uploadedFile => {
      $w("#image1").src = uploadedFile.fileUrl;
 let url = uploadedFile.fileUrl;
      console.log('File url:', uploadedFile.fileUrl);
 })
 })
 .catch( (uploadError) => {
 let errCode = uploadError.errorCode; // 7751
 let errDesc = uploadError.errorDescription; // "Error description"
} );
}

//top view img
export function uploadButton2_change(event) {
$w("#uploadButton2").uploadFiles()
 .then( (uploadedFiles) => {
    uploadedFiles.forEach(uploadedFile => {
      $w("#image12").src = uploadedFile.fileUrl;
 let url = uploadedFile.fileUrl;
      console.log('File url:', uploadedFile.fileUrl);
 })
 })
 .catch( (uploadError) => {
 let errCode = uploadError.errorCode; // 7751
 let errDesc = uploadError.errorDescription; // "Error description"
} );
}

//입면도(첨부만 눌러도 되는거)
export function uploadButton3_change(event) {
$w("#uploadButton3").uploadFiles()
 .then( (uploadedFiles) => {
    uploadedFiles.forEach(uploadedFile => {
      $w("#image13").src = uploadedFile.fileUrl;
 let url = uploadedFile.fileUrl;
      console.log('File url:', uploadedFile.fileUrl);
 })
 })
 .catch( (uploadError) => {
 let errCode = uploadError.errorCode; // 7751
 let errDesc = uploadError.errorDescription; // "Error description"
} );
}

//out img
export function uploadButton4_change(event) {
$w("#uploadButton4").uploadFiles()
 .then( (uploadedFiles) => {
    uploadedFiles.forEach(uploadedFile => {
      $w("#image14").src = uploadedFile.fileUrl;
 let url = uploadedFile.fileUrl;
      console.log('File url:', uploadedFile.fileUrl);
 })
 })
 .catch( (uploadError) => {
 let errCode = uploadError.errorCode; // 7751
 let errDesc = uploadError.errorDescription; // "Error description"
} );
}

//in img
export function uploadButton5_change(event) {
$w("#uploadButton5").uploadFiles()
 .then( (uploadedFiles) => {
    uploadedFiles.forEach(uploadedFile => {
      $w("#image15").src = uploadedFile.fileUrl;
 let url = uploadedFile.fileUrl;
      console.log('File url:', uploadedFile.fileUrl);
 })
 })
 .catch( (uploadError) => {
 let errCode = uploadError.errorCode; // 7751
 let errDesc = uploadError.errorDescription; // "Error description"
} );
}

//stage img
export function uploadButton6_change(event) {
$w("#uploadButton6").uploadFiles()
 .then( (uploadedFiles) => {
    uploadedFiles.forEach(uploadedFile => {
      $w("#image16").src = uploadedFile.fileUrl;
 let url = uploadedFile.fileUrl;
      console.log('File url:', uploadedFile.fileUrl);
 })
 })
 .catch( (uploadError) => {
 let errCode = uploadError.errorCode; // 7751
 let errDesc = uploadError.errorDescription; // "Error description"
} );
}

//seat img
export function uploadButton7_change(event) {
$w("#uploadButton7").uploadFiles()
 .then( (uploadedFiles) => {
    uploadedFiles.forEach(uploadedFile => {
      $w("#image17").src = uploadedFile.fileUrl;
 let url = uploadedFile.fileUrl;
      console.log('File url:', uploadedFile.fileUrl);
 })
 })
 .catch( (uploadError) => {
 let errCode = uploadError.errorCode; // 7751
 let errDesc = uploadError.errorDescription; // "Error description"
} );
}

//setup img
export function uploadButton8_change(event) {
$w("#uploadButton8").uploadFiles()
 .then( (uploadedFiles) => {
    uploadedFiles.forEach(uploadedFile => {
      $w("#image18").src = uploadedFile.fileUrl;
 let url = uploadedFile.fileUrl;
      console.log('File url:', uploadedFile.fileUrl);
 })
 })
 .catch( (uploadError) => {
 let errCode = uploadError.errorCode; // 7751
 let errDesc = uploadError.errorDescription; // "Error description"
} );
}

//entrance img
export function uploadButton9_change(event) {
$w("#uploadButton9").uploadFiles()
 .then( (uploadedFiles) => {
    uploadedFiles.forEach(uploadedFile => {
      $w("#image19").src = uploadedFile.fileUrl;
 let url = uploadedFile.fileUrl;
      console.log('File url:', uploadedFile.fileUrl);
 })
 })
 .catch( (uploadError) => {
 let errCode = uploadError.errorCode; // 7751
 let errDesc = uploadError.errorDescription; // "Error description"
} );
}
2

Looks like the problem is with your database permissions. Please change the permission to “Custom” and change all fields to “Everyone” then test it in live mode.

3

As Rashid stated, you most likely are encountering issues with permissions. One way to fix the issue is by using Everyone as Rashid suggests.

If your data contains sensitive information, you might want to consider moving the query to a backend file where it will be hidden from the view of your site visitors. You can set the permissions to Private Data , and perform the insert as an admin by suppressing the permissions like this:

wixData.insert("Team", toInsert, {"suppressAuth": true})
4

Thanks Rashid, Yisrael.
It works. The problem is database permissions!!!